How to autocomplete a column before reaching a new value, then autocomplete using this value

Question

I was wondering how can I authorize a column with a specific value until it reaches a new value in the same column, and then autocomplete with that?

I tried using Excel, but I do not know how to do this. I can also use unix commands if there is a method for this (I just could not figure out what one of them was).

Example. How can i do this:

12345 83492 A 28397 18723 20983 39847 98237 28394 B 09477 34566 03940 76382 C 39348 38495 

In it:

 12345 83492 A 28397 18723 A 20983 39847 A 98237 28394 B 09477 34566 B 03940 76382 C 39348 38495 C 

Any help would be greatly appreciated!

EDIT - if you have a way to do this in MySQL, I can do it too

Answer 1

The easiest way I know is to do this using the formula in the column on the right.

So, for example, you will have:

 COL A: COL B: COL C: COL D: 12345 83492 A =C1 28397 18723 =IF(C2="",D1,C2) 20983 39847 98237 28394 B 09477 34566 03940 76382 C 39348 38495 

Then drag the formula into D2 all the way down, then you can copy / paste the values.

Answer 2

If you are not interested in VBA / Formula. Then you can try the simple steps:

• Select a range. For example, C1:C7
• Press the F5 keyboard function key. The (Go To) dialog box appears.
• Click "Special"
• From the options seen (Radio button), select "Forms" and click "OK"
• Press the keyboard key = (equal sign) and press the Arrow-Up key once.
• Then press CTRL+Enter together to see the results