[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

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
0
Rayne
Asked:
Rayne
1 Solution
 
Saqib Husain, SyedEngineerCommented:
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
0
 
RayneAuthor Commented:
Hello Ssaqibh,

Thank you a million. This is GOLD :)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now