rows and columns

  • Thread starter Thread starter upolu
  • Start date Start date
If you mean "row data" into "columnar data", highlight the row of data,
select COPY, click on the target cell then EDIT > PASTE SPECIAL > Transpose >
OK.
 
Hi,

If you data is in range C5:C9 and you want to transpose this to F5:J5, you
can use the transpose() array formula. Highlight F5:J5 and type
=transpose(C5:C9) and now press Ctrl+Shift+Enter.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Hi,

You can also use a combination of some of the following functions: OFFSET,
INDEX, INDIRECT. But details would depend on details of your data.
 
Back
Top