Taking Info from repeating tables

[falkstrom]

I have a spreadsheet with repeating tables of different data, arranged something like this.

40-50-60-70-80
50-60-70-80-90
30-40-50-60-70
A-B
40-50-60-70-80
50-60-70-80-90
30-40-50-60-70
C-D
40-50-60-70-80
50-60-70-80-90
30-40-50-60-70
E-F

This repeats around 3000 times. I want to extract certain values and arrange them in rows for each repetition. For example, I want the A-B tag at the bottom of each set of data, and the third and fourth value of the second row. So, in a new sheet they would be arranged like this:

A-B-70-80
C-D-70-80
E-F-70-80

and so on.

I hope this makes sense, thanks if anyone can help.

[zbor]

Can you upload example?

[falkstrom]

The file I am using is on a computer without internet access, so I cannot upload that, but I will upload an example with a similar format.

In the example file there are matrixes that repeat over and over in the same format. I want the cells that are highlighted in the file to be transferred to a new sheet, such that they will come up as:

John Smith-88-19-97-35
Jake Brown-50-35-60-49
Jennifer Jones-64-81-44-87
Alex Henry-98-63-10-3
Mike Johnson-79-48-72-9

Does this make sense?

[martindwilson]

one way see attached