I'm new to this forum
Here is my problem:
I have a spreadsheet containing 3 columns and almost 24,000 rows of data.
Let's say: Column A is "First Name", Column B is "Last Name" and Column C is "Tracking ID".
The first 6,700 entries in Column C each cell already has its own unique, sequential "tracking" id which was entered manually by someone else.
I'm really hoping that there is a way for me to use the already established pattern to populate the remaining 17,000 cells.
I tried to highlight and extending but this did not work.
I imagine that it's probably because the pattern is a bit complex?
It is: "3digits"_"a letter [A-D]""a number [1-8]" starting with 001_a1.
... and it continues this way to the last filled cell:
I need a way to continue this pattern for the remaining approx. 17,000 cells.
ANY help/ideas/shortcuts/ANYTHING will be greatly appreciated; I can't even think about how long it will take to manually enter.
EDIT: I've attached a sample file. Column C contains the first 321 actual tracking numbers.