row picking

[Micronaut]

I have a large matrix if data made up of blocks of 8 rows of number
across 12 columns with a blank row between each set

There are 51 blocks of data, out of which I need to group each row fro
each set together. e.g, i need to pick row 1 from each of the 51 set
and put them together, row 2's all together, row 3 etc, down all
rows.

Is it possible for Excel to sort the data in this way, or mark each o
these rows somehow to refer to them by cells?

Thanks for your help. :confused

 

[Max]

One way to try ..

Assume the 51 blocks are named sequentially as: TBL1, TBL2, ... TBL51

In a new sheet
-----------------
Put in A1: 1

Put in A2:
=OFFSET(INDIRECT("TBL"&ROW(A1)),$A$1-1,COLUMN(A$1)-1,)

Array-enter the formula in A2 with CTRL+SHIFT+ENTER
instead of just pressing ENTER

Copy A2 across to L2, fill down to L52

This will return all the row1's from each of the 51 blocks in A2:L52, viz.:

Row1 from TBL1 in A2:L2,
Row1 from TBL2 in A3:L3,
....
Row1 from TBL51 in A52:L52,

The # entered in A1 is the row# to be extracted from each of the 51 blocks.

Entering "1" in A1 will extract all the row1's in A2:L52,
entering "2" will extract all the row2's, and so on

Just enter the row# as desired / each row# in turn into A1
and then copy > paste special > values elsewhere

 

[Max]

A clarification ..

Assume the 51 blocks are named sequentially as: TBL1, TBL2, ... TBL51

Assume data is in cols A to L, row1 down
with a blank row in between each block of 8R x 12C

To name, just select the block
(example: select A1:L8, the "1st" block),
then type the name in the namebox*: TBL1
and press Enter

*box with the droparrow to the left of the formula bar

Repeat to name the next block
(example: select A10:L17, the "2nd" block)
type in the namebox: TBL2, press Enter ..

And so on .. to name the rest of the 49 blocks: TBL3, TBL4, ... TBL51

(Naming all 51 blocks shouldn't take you more than 3-5 min <g>)