Copy contents in a row and paste in a column

C

CJMFH

I'd like to take data in a row and reformat it, putting it into a column.

Can anyone help?

Thanks -:)
 
D

Dave Peterson

Select your range
edit|copy
select a cell not in that range
edit|paste special|check 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

Similar Threads

Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Paste options button disappears 0
sqlite-odbc write conflict 2
List all tables, including document structure 0
Remove all formatting charactersf except for paragraph and cr/lf 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Word VBA Copy Heading and Content 4

Top