Copy one Column Across One Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey guys,

I would like to take one column of data and copy it across one row.,
so, I want the data to go left to right across the spreadsheet instead of
top to bottom.

If you have a suggestion to solve this, macro or whatever, could you please
email it
to me at:

(e-mail address removed)

thanks,
kevin rea
 
Kevin

If the column contains no more than 255 rows of data(256 if you are pasting
below row 256) you can copy it and select B1 and Paste
Special>Transpose>OK>Esc.

Gord Dibben Excel MVP
 
Back
Top