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