Hello, this is my first post here. I stumble upon this Awesome Website in search for some answers to my MS Excel questions. I kinda having a hard time on one of the exercises given to me. Any kind soul can help me with this?
Task: Transform the table below in such a way that all the items in a row start with the same letter. Consequently, the letters "a" through "j" should run from top to bottom in the first column. I attached the spreadsheet for everyone's reference.
Thanks in advance!
Lanie<3
Hi and welcome to the forum!
Your description is a little vague, but perhaps this is what you want: in cell B14 and copy across and down:
=INDEX($B$2:$K$11,COLUMNS($A:A),ROWS($1:1))
Regards
inal30,
Easiest way is to copy your original table then right click the destination cell, paste special and check transpose.
For your Uppercase use the formula
To save typing all those in..
Please Login or Register to view this content.
Hope that helps
Dave H
- Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
- Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
Thank you so much! This is perfectly the result I needed
Originally Posted by XOR LX
Last edited by inal30; 08-29-2013 at 11:11 AM.
--Thanks Dave ^^
"Easiest way is to copy your original table then right click the destination cell, paste special and check transpose.
For your Uppercase use the formula
=UPPER(cell reference)To save typing all those in.
Hope that helps
Dave H
Last edited by inal30; 08-29-2013 at 01:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks