I have data in Excel that is missing repeating values.
It looks like this...
ID Accnt
10 111
222
333
20 444
555
777
...but I wish to have the repeating values added...
ID Accnt
10 111
10 111
10 222
10 222
10 222
10 333
20 444
20 444
20 444
20 555
20 777
20 777
I've messed with some macros...but the problem is that the number of rows for each ID may vary as well as the number of account rows for each ID. Also the order may vary. Thus, I'd need an approach that can tackle this columb by column. It would have to start at row 1, and copy or fill down the same value up until the new value below. Then the process would need to repeat.
Not sure whether auto fill or auto copy or what is the best approach.
Any help would be appreciated.
Thanks!
Chris
It looks like this...
ID Accnt
10 111
222
333
20 444
555
777
...but I wish to have the repeating values added...
ID Accnt
10 111
10 111
10 222
10 222
10 222
10 333
20 444
20 444
20 444
20 555
20 777
20 777
I've messed with some macros...but the problem is that the number of rows for each ID may vary as well as the number of account rows for each ID. Also the order may vary. Thus, I'd need an approach that can tackle this columb by column. It would have to start at row 1, and copy or fill down the same value up until the new value below. Then the process would need to repeat.
Not sure whether auto fill or auto copy or what is the best approach.
Any help would be appreciated.
Thanks!
Chris