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
