Dear All,
could you tell me how can I transpose values from a ROW from spreadsheet 2 in aCOLUMN in spreadsheet 1?!
Thank you :-)
Dear All,
could you tell me how can I transpose values from a ROW from spreadsheet 2 in aCOLUMN in spreadsheet 1?!
Thank you :-)
Have a look at this site:
http://cpearson.com/excel/lists.htm#ReverseOrder
and look for " transposing a column into a row"
1. Highlight the destination cells
2. type
=Transpose(srcrange)
(where src range is the src data, e.g. Sheet1!A1:A5)
Do not hit enter when you are done typing the formula
3. Hit SHIFT-CTRL-ENTER
That's you you enter in an array formula, which is a formula that returns multiple values and you want them to each be in a cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks