formula to fill in blank on spreadsheet

[Guest]

I received a spreadsheet with info in the two columns below to the left. I
need the sheet to look like the two columns on the right however there is >
50k lines and I do not want to fill in manually. is there any formual to
fill it in automatically? 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

 

[Frank Kabel]

Hi
try the following formula in C1
=A1 & " " & B1
in C2 enter
=IF(OR(A1<>A2,B1<>B2),A2 & " " & B2,"")
copy this formula down for all rows.
You can simplify the fill down procedure by double-clicking on the
lower right corner of cell C2

 

[Guest]

I don't think I expressed myself correctly. in the example I sent
you....column a and b is what I received.....c is a blank column and column d
and e is what I need it to look like. so when you say to enter the formula
in column c I am lost.

 

[Guest]

i don't think i expressed myself correctly. in the example i noted....column
a and colum b is what I received. column c is blank. column d and column e
is what I need it to look like. so I am lost with the formula in column c.
thanks

 

[Ken Wright]

Ahhh - You just want to get rid of the duplicates I think, yes??

If so then select Cols A & B, do Data / Filter / Advanced Filter / Check 'Copy
to another location and choose D1 and then make sure you tick the bottom of the
box where it says unique records only. Hit OK and you are done.

 

[Debra Dalgleish]

There are instructions here for filling in the blank cells:

http://www.contextures.com/xlDataEntry02.html