Y
yar
How can I change a column of data to a row of data?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
TRANSPOSE
G
Gord Dibben
Copy>Paste Special>Transpose.
Paste area cannot overlap copy area and you are limited by number of columns
in a row.
Gord Dibben MS Excel MVP
Paste area cannot overlap copy area and you are limited by number of columns
in a row.
Gord Dibben MS Excel MVP
Y
yar
yar said:How can I change a column of data to a row of data?
Thanx found my answer but data is limited to little more than 250 entries
D
David Biddulph
If you are talking of the 256 column limit in Excel 2003, remember that
Excel 2007 changes that to 16384 columns.
Excel 2007 changes that to 16384 columns.