fill in blank cells with info above

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I received a spreadsheet with two columns like the one below on the left. I
need to get it in the format on the right however there is > 50,000 groups so
I do not want to do it manually. is there a formula I can use? thanks


0007220 XYZ CORP 0007220 XYZ CORP
0007220 XYZ CORP
0007220 XYZ CORP
0007220 XYZ CORP

0007270 ABC CORP 0007270 ABC CORP
0007270 ABC CORP
0007270 ABC CORP
0007270 ABC CORP
0007270 ABC CORP
0007270 ABC CORP
0007270 ABC CORP

0007400 LMN CORP 0007400 LMN CORP
0007400 LMN CORP
0007400 LMN CORP
0007400 LMN CORP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to fill in blank on spreadsheet 5
vertical fill 2
Sum Question 2
Requesting Help with Counting in a Pivot but Excluding Duplicates 3
Summing by year in a cross tab query 2
If or something else for Partial Text Extraction/Reference 1
Create 3rd data set off comparison of 2 other sets 2
Identify Duplicates (Group Records First) 6

Back
Top