Adding rows based on cell value

[Frank_Hartmann]

Hi folks,

I have this table:

and i need to get an extra row above each header cell:

LOAD * INLINE [
dim1, dim2, dim3
1, 0x3B1B, header
2, n/a, parameter
3, n/a, value
4, n/a, parameter
5, n/a, value
6, 0x3B1F, header
7, n/a, parameter
8, n/a, value
9, 0x21DE, header
10, n/a, parameter
11, n/a, value
];

Any ideas how to achieve that?

[LRuCelver · Accepted solution]

Data:
NoConcatenate Load * Inline [
dim1, dim2, dim3
1, 0x3B1B, header
2, n/a, parameter
3, n/a, value
4, n/a, parameter
5, n/a, value
6, 0x3B1F, header
7, n/a, parameter
8, n/a, value
9, 0x21DE, header
10, n/a, parameter
11, n/a, value
];

Concatenate(Data) Load
	dim1 - 0.5 as dim1,
    'Your dim2 here' as dim2,
    'Your dim3 here' as dim3
Resident Data
Where dim3 = 'header';