rows and columns

J

JBeaucaire

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.
 
A

Ashish Mathur

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
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Compare identifier columns from 2 sheets - remove rows that are dups 2
Finding identical rows in a list 6
#REF! 1
Column to row 3
convert columns to rows 6
numbering 1
Converting Rows into Columns 3

Top