Converting rows of data into columns

  • Thread starter Thread starter Ian McD Wood
  • Start date Start date
Ian

If the number of rows does not exceed 256 you can use Copy>Paste
Special>Transpose.

Or use the TRANSPOSE Function(again limited)

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Convert a square of data into a PivotTable? 1
View Pivot Table Source data as a Data Table 6
Pivot Table operation is different 1
Difference column in PivotTable 1
GetPivotData 1
Pivot table - problem with field 4
Can I rotate data in Excel table (rows to columns, and vv)? 6
PivotTable - Sum and Count 1

Back
Top