how to transpose a single column list into 3 columns

hi Folks
Got a list in the attached file. name, phone number, website (listed vertically). I want this to be listed horizontally as per desired format sheet. I've tried transpose, transpose (array entered) and so far I've got the first one repeated.
Any suggestions? Thanks.
EE-transpose.xlsx
agwalshAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
In A1 on sheet3 enter:
=INDEX('Original data'!$A:$A,(ROW()-1)*3+COLUMN())
and copy across to B1 and C1 then fill those three down as far as necessary.
0
 
agwalshAuthor Commented:
Absolutely f****** brilliant :-) THANK YOU :-)
0
 
agwalshAuthor Commented:
An elegant beautiful formula to solve a transpose question....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.