There is worksheet that has data rows for each account. Each account will always have 4 rows of info. Note in column A – the accounts are repeated for the very first occurrence and is blank for the rest of the rows till a new account starts. What can be done the best way to do this?
Repeat each account for the rows it owns, so means that Ac1 repeats 4 times in column A instead of one time.
Remember I am dealing with zillion number of rows. So the fastest way preffered