1
The Hydlaa Plaza / Anyone good with Excel?
« on: March 25, 2008, 07:13:10 pm »
Hey everyone. I have et another problem at work I was hoping someone here could solve my problem.
Okay so I have a list of thousands of names and addresses which are all in one collumn in different cells. For example:
Bob Smith
1000 Planeshift St.
Hydlaa, Ca 91201
John Smith
2000 Planeshift St.
Hydlaa, Ca 91201
And I need it split into 3 columns. Example:
Bob Smith | 1000 Planeshift St. | Hydlaa, CA 91201
Is there an automated way where it can take row 1 and keep it in place, move row 2 to column 2, row 3 to column 3 then just keep repeating that pattern?
Thanks for the help everyone.
And yes Hydlaa is located in California.
Okay so I have a list of thousands of names and addresses which are all in one collumn in different cells. For example:
Bob Smith
1000 Planeshift St.
Hydlaa, Ca 91201
John Smith
2000 Planeshift St.
Hydlaa, Ca 91201
And I need it split into 3 columns. Example:
Bob Smith | 1000 Planeshift St. | Hydlaa, CA 91201
Is there an automated way where it can take row 1 and keep it in place, move row 2 to column 2, row 3 to column 3 then just keep repeating that pattern?
Thanks for the help everyone.
And yes Hydlaa is located in California.