Rayne
asked on
Question This
Hello ,
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.
account T_type
Ac1 T1
Ac1 T2
Ac1 T3
Ac1 T4
Ac2 T1
Ac2 T2
Ac2 T3
Ac2 T4
Ac3 T1
Ac3 T2
Ac3 T3
Ac3 T4
Ac4 T1
Ac4 T2
Ac4 T3
Ac4 T4
Remember I am dealing with zillion number of rows. So the fastest way preffered
myQ.xlsx
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.
account T_type
Ac1 T1
Ac1 T2
Ac1 T3
Ac1 T4
Ac2 T1
Ac2 T2
Ac2 T3
Ac2 T4
Ac3 T1
Ac3 T2
Ac3 T3
Ac3 T4
Ac4 T1
Ac4 T2
Ac4 T3
Ac4 T4
Remember I am dealing with zillion number of rows. So the fastest way preffered
myQ.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you a million. This is GOLD :)