Isn't there any easy way to move data in a column to a row?
A ak Jul 29, 2003 #2 Select the data in the column. Copy the data Select the cell to begin the row then Go to Edit - Paste Special - Transpose.
Select the data in the column. Copy the data Select the cell to begin the row then Go to Edit - Paste Special - Transpose.
A Andy Brown Jul 29, 2003 #4 With your data in eg: A1:Z1 - Select it. Copy it. Select A2. Edit >> Paste Special >> Transpose >> OK. Rgds, Andy
With your data in eg: A1:Z1 - Select it. Copy it. Select A2. Edit >> Paste Special >> Transpose >> OK. Rgds, Andy
