Social
"My latest blog article on Fimodo http://bit.ly/8ZrZeR"
Who is Plum?
Based in Sydney, Australia, Plum Solutions has been providing professional financial modelling solutions since 2004.Read more...
Dear Sir/Madam,
Would appreciate if you could advise which function or steps to use to convert a horizontal table to vertical table, i.e
From horizontal table
A B C D E
1 2 3 4 5
to the following vertical table
A 1
B 2
C 3
D 4
E 5
Thank you,
Regards
Ong
"My latest blog article on Fimodo http://bit.ly/8ZrZeR"
Based in Sydney, Australia, Plum Solutions has been providing professional financial modelling solutions since 2004.
Hi Ong,
If you want the values to be hard-coded, you can use paste special. Highlight the data, copy it, go to a blank cell and right-hand click. Select Paste Special, and select both VALUES and TRANSPOSE. This will transpose the hard-coded data from horizontal to vertical or vice versa.
If however, you want the data to be linked, you would need to use a TRANSPOSE array formula. There are some instructions on how to do this here: http://office.microsoft.com/en-us/excel/HP052093191033.aspx
I hope this helps.
Danielle.
Submitted by danielle on Fri, 26/06/2009 - 11:19.
Post new comment