Flip Col A to be Row 1

G

Gee

There's a way to flip your data so that all the headers in
col A can convert to be colunm headers in row 1. How do
you do that?
Thanks,
Gee
 
F

Frank Kabel

Hi
- copy the data in column A (max of 256 rows)
- select your target range
- goto 'Edit - Paste Special' and choose 'Transpose'
 

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

Top