Return Single Row of Numeric Data to Single Column

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1

Hi!

Try this:

=INDEX(C$13:DV$13,ROWS($1:1)*2)

Copy down as needed.

Biff

"Sam via OfficeKB.com" <u4102@uwe> wrote in message
news:58f0e24c9bcaa@uwe...
> 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
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200512/1

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

Hi Biff,

That was brilliant, thank you.

>=INDEX(C$13:DV$13,ROWS($1:1)*2)
>
>Copy down as needed.

Cheers,
Sam

Biff wrote:
>Hi!
>
>Try this:
>
>=INDEX(C$13:DV$13,ROWS($1:1)*2)
>
>Copy down as needed.
>
>Biff
>
>> Hi All,
>>
>[quoted text clipped - 14 lines]
>> Thanks
>> Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1

Hi Gord,

Thank you for reply and insight using F5:

>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.

I'm sure the above will be of use to me. However, I've used Biff's nifty
solution and I also avoid deleting any columns.

Cheers,
Sam

Gord Dibben wrote:
>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
>
>>Hi All,
>>
>[quoted text clipped - 12 lines]
>>Thanks
>>Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1