Collapsing Cells

[Kip]

I have a spreadsheet that has data I want to extract that resides in
every 4th cell down. So for example:

Row 1 - Name
Row 2 - Address
Row 3 - City State Ziop
Row 4 - Phone Number

It is row 4 I want to extract and I am looking for a way to extract
ONLY the data in each 4th row into a spreadsheet that will have all
phone numbers listed.

Thanks.

 

[Gord Dibben]

In A1 of Sheet2

=OFFSET(Sheet1!$A$1,4*ROW() -1,0)

Drag/copy down.


Gord Dibben MS Excel MVP

 

[ozgrid.com]

=A4 in B4 and then select B4:B6 and drag down by Fill Handle.
http://www.ozgrid.com/Excel/excel-fill-handle.htm

 

[Bruce Sinclair]

I have a spreadsheet that has data I want to extract that resides in
every 4th cell down. So for example:

Row 1 - Name
Row 2 - Address
Row 3 - City State Ziop
Row 4 - Phone Number

It is row 4 I want to extract and I am looking for a way to extract
ONLY the data in each 4th row into a spreadsheet that will have all
phone numbers listed.

Well, if you want to do this as a one off, you could add an index column
that numbered your rows (1,2,3,4 repeated), then filter your SS to show only
"4" in that column, copy what you now see and paste to another sheet. Done.