Converting from Row to Columns
 

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

--
Message posted from http://www.ExcelForum.com

Converting from Row to Columns
 

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 A1:D1

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.

--
Regards,
Tom Ogilvy

"miket2799 " wrote in message
...
Hello All....any help you can provide would be greatly appreciated. I am
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.


---
Message posted from http://www.ExcelForum.com/