Replacing Rows with columns.

  • Thread starter Thread starter OL
  • Start date Start date
If you copy the table you can Paste Special | Transpose it to a different
location. You could then copy it back to where it was.

Code to do this might look like this:

Range("D9:F11").Copy
Range("H9").PasteSpecial _
Paste:=xlAll, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=True
Range("H9:J11").Cut Range("D9")
Range("D9").Select

Regards

Trevor
 
Yes

Copy>Paste Special>Transpose.

Note: if you have more than 256 rows this cannot be done.

Gord Dibben XL2002
 
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

rotate a sheet on its axis 6
Rotating Data 1
Can I rotate data in Excel table (rows to columns, and vv)? 6
Changing column and row ID's 1
interchange columns with rows 2
How do I rotate a worksheet in Excel? 1
MS word Find and Replace using Regex - Help required 0
In Excel can I rotate a column from vertical to horizontal. 3

Back
Top