MrExcel Publishing
Your One Stop for Excel Tips & Solutions

transpose column to row but leave blank cells in column


Posted by yaneckc on July 22, 2000 6:25 PM

Subj: transpose column to row but leave blank cells in column
Date: 7/16/00 7:20:38 PM Eastern Daylight Time
From: YANECKC
To: ask@MrExcel.com

IS THERE A WAY TO TRANSPOSE A COLUMN WITH TEXT AND BLANK CELLS
TO A ROW WITH JUST TEXT CELLS.
IF NOT IS THERE A WAY TO CLICK ON JUST THE CELLS THAT I NEED IN A
COLUMN TO BE TRANSPOSED TO A ROW.


Posted by Ada on July 23, 0100 3:02 AM


Yaneckc
If the data in the cells are NOT from formulas :-

Select the column with the data
Select Edit>Go To>Special>Constant>OK
Select Edit>Copy
Activate receiving cell
Select Edit>PasteSpecial>Transpose>OK

If any of the starting cells contain data from formulas, first convert them to values (Copy>PasteSpecial>Values)

Ada