How to merge several Excel tables into one?

Question

I have 3000 tables like in this example:

I need to merge them into one and I’m using the remote:

=ÍNDICE(TXT!$B$1:$B$200,CORRESP(MAIOR(SE(TXT!$A$1:$A$200="Last Name:",TXT!$B$1:$B$200,""),1),TXT!$B$1:$B$200,0))

The problem is that you just present me with the following:

Is this command the right one for this case? If so, what am I doing wrong?

PS: I only need the data marked in csv sheet

Answer 1

If the intervals are regular, you can do the following: Create an auxiliary column in the CSV tab with title "line" in A2

in A3 fill with number 8, which is the first line of the TXT tab card

in A4 fill with =A3+15

the formula for cell B3 will be =índice(txt!$b:$b;$A3;1)

the C3 formula will be =índice(txt!$b:$b;$A3+1;1)

the formula for cell D3 will be =índice(txt!$b:$b;$A3+2;1)

And so on and so forth...