Copy column and paste horizontal

  • Thread starter Thread starter CLAY
  • Start date Start date
C

CLAY

I'm trying to copy a column and have it paste it
horizontally.

Example:
column1
11112
11113
11114
11115

Change to:
column1 11112 11113 11114 11115

Any help is appreciated.

Clay
 
Hi
try
- copy your data
- goto 'Edit - Paste Special' and choose 'Transpose' as action
 
Use "Paste Special" and check the "Transpose" box

Chris O
________________________________________________
 
Hi Clay

Select the cells and copy
Right click on cell B1 or so and choose PasteSpecial
Check Transpose

Remember that you have only 256 columns
 
Back
Top