Sometimes I get data downloaded from a report from our main system and it comes in the format:
A 123
456
789
B 333
444
555
C 22222
33
123
etc
I want to easily fill the gaps in between so that it looks like:
A 123
A 456
A 789
B 333
B 444
B 555
C 22222
C 33
C 123
etc
I don't know if there is a function or feature to do this or whether it can only be done with VBA.
Bookmarks