conditional import

[AmCh]

Hi all,

given the following xls. table as an example:

x	a	b	c	d
1	2	1	5	2
2	3	4	5
3	5	7	1
1	8	3	7	5
2	2	6	5
1	0	9	3	8
2	2	8	1
3	5	5	5
4	7	2	6

1. I want to import the fields a,b,c separately according to the values of the field x:

Always import separately from X=1 to the next X=1 (excluded).

As an example:

a

2

3

5

a

8

2

a

0

2

5

7

same for b and c.

2. For d I only want to import single values that correspond to X=1.

//FROM [alpha] (ooxml, embedded labels, header is 1 lines, table is beta)

Any help please?
Thanks in advance

[QFabian]

😊

[AmCh]

Nice, it works!
Thank you for your help.