Collapsing Cells


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

Advertisements

G

Gord Dibben

In A1 of Sheet2

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

Drag/copy down.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top