Jul 25 2020 12:10 AM
Hi, please, how thousands of rows in one column could be numbered, without dragging and with a letter prefix? Example:
AHJS1000
AHJS1001
AHJS1002
...
thank you
Jul 25 2020 02:59 AM
SolutionJul 28 2020 02:18 AM
How to do it so that the numbers remain the same even after moving to another row? To make them static values.
Jul 28 2020 12:44 PM
That is what you would get if you entered the first value in a cell, then dragged down. But you didn't want that...
Jul 29 2020 04:45 AM
Because I have thousands of lines, do you know of any alternative?
Jul 29 2020 06:00 AM
If you want the values in a column adjacent to a populated column that has no blanks, you can enter the starting value in the first cell, then double-click the fill handle in the lower right corner of the cell. Excel will automatically fill the column down to the last used row.
Alternatively, enter the starting value in the first cell. With that cell still selected, scroll down and then hold down Shift while selecting the last cell. On the Home tab of the ribbon, click Fill > Flash Fill.
Jul 29 2020 07:50 AM
Thank you very much ;)
Jul 29 2020 09:21 AM
Power Query was built to transform data. It will also push one towards the use of Tables which is probably the No1 improvement that can be made to any data analysis workbook.
Jul 25 2020 02:59 AM
Solution