col to row in different sheet

[braddini]

ok here is my prob
i have a worksheet that has some data stored in col A starting on row 3 to undeterimne row number. i need to select that data
then have if posted in on row on another sheet.
in other words i need to have excel take a col of cell data and convert it to a row of data,

 

[Mark W.]

On 2002-04-17 09:59, braddini wrote:
ok here is my prob
i have a worksheet that has some data stored in col A starting on row 3 to undeterimne row number. i need to select that data
then have if posted in on row on another sheet.
in other words i need to have excel take a col of cell data and convert it to a row of data,

You could use Edit | Paste Special... Values Transpose

 

[braddini]

cool thanks