How do I transpose one row into three columns?

Using Excel for Mac 2011

I have one row of data I want to transpose into three columns by taking the row and splitting it after each third cell.

The data looks like this:

[first name][last name][Country][first name][last name][Country][first name][last name][Country][first name][last name][Country]... I have over 1200 cells.

I want it to change it to look like this:
[first name][last name][Country]
[first name][last name][Country]
[first name][last name][Country]
[first name][last name][Country]...

It seems like this should be easy. Oh, and there is no merge section in the layout tab

Thanks in advance.

Look at the Data tab. There is a feature Text to Columns which should do the trick.

Good luck

PS If you still have trouble perhaps attaching a file would help.

Use Crazyeddie method,

I'll give you a small explanation about his idea.

For that
1. You have to replace "][" to "-"
2. Select that column --> Data tab --> Text to Columns --> Delimited --> Next --> Check Other and put "-" --> Finish.

3. Now you have all data in one row but lot of columns.
4. Copy all data and paste in another sheet using special paste columns to row.(Transpose)
5. Now you have all data in one column but lot of rows.
6. Use this formula in every "first name" row

Please Login or Register  to view this content.

(B1,B4,B7....)

Note: If you have any problem to put this formula in every "first name" row, let us know.

7. Then again use the same steps 1 & 2

I hope you Understood the concept.