Collapsing Cells

  • Thread starter Thread starter Kip
  • Start date Start date
K

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.
 
In A1 of Sheet2

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

Drag/copy down.


Gord Dibben MS Excel MVP
 
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.
Click to expand...

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