agwalsh
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
An elegant beautiful formula to solve a transpose question....
ASKER