Converting from Row to Columns

[miket2799]

Hello All....any help you can provide would be greatly appreciated. I a
trying to copy a data that is just in one column to several columns
Below is the example on what I am looking for.

Data Currently stored in just one column

XYZ Company
124 Anywhere, US
555
$7890
ABC Company
123 Maine, US
455
$888
AA Auto Parts
222 Illionois, US
768
$999

This is the way I would like the data to be

XYZ Company 124 Anywhere, US 555 $7890
ABC Company 123 Maine, US 455 $888
AA Auto Parts 222 Illionois, US 768 $999


I hope this helps. Again, thanks a lot for all your help.

Yes, I can do this manually; however, I have 50,000 records to go thru

 

[Tom Ogilvy]

insert a second sheet. In A1 put in the formula

=INDIRECT("sheet1!A" & (ROW()-1)*4+COLUMN())

Change Sheet1 to reflect the sheetname of the sheet that contains the data

Drag the cell to the right to column 4

Now Select A11

now drag fill down the column until you run out of data


Select all the cells and do Edit=>Copy and then Edit=>Paste special , then
values.

That will replace the formulas with the data they produce.