Select row 13.

F5>Special>Blanks>OK

Edit>Delete>Entire Columns or Shift Cells Left, your choice depending upon
what's in other columns/rows that you may not want deleted.

Re-select the row and Copy.

Select a cell in column A below your data and Paste Specail>Transpose>OK>Esc.


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 22:56:28 GMT, "Sam via OfficeKB.com" <u4102@uwe> wrote:

>Hi All,
>
>I have a Row of numeric data ( in individual columns) that I would like
>returned to individual cells in a single column.
>
>My data starts in Column C Row 13 to Column DV Row 13. However, every other
>Column in the Row of data is blank. Is it possible to return the data
>excluding the blank columns, so there are no blank cells when the data is
>returned to a single column?
>
>Sample Data Layout:
>C13 BLANK, D13 70, E13 BLANK, F13 45, G13 BLANK, H13 50, I13 BLANK, J13 63,
>K13 BLANK etc.
>
>Thanks
>Sam