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
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Select the column A range
press F5
Click on special
Select blanks
Click OK
type   =
from the keyboard move the cursor one cell up
press ctrl-enter
RayneAuthor Commented:
Hello Ssaqibh,

Thank you a million. This is GOLD :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.