Setting N row as header's row

[Stanislaw]

Hello everybody,

Let's say I have an Excel file similar to this:

blablalbllb	blabla	bla blaaaa
bla bla bla bla	bla bla bla
Date	Tea	Coffee	Soda	Water
2020/11	12	35	7	81
2020/12	15	33	9	81

I'd like to remove the first two rows and set the third one as a header's row.

I managed to use the sample tool and skip 2 rows, but instead of having this:

Date	Tea	Coffee	Soda	Water
2020/11	12	35	7	81
2020/12	15	33	9	81

I have this:

F1	F2	F3	F4	F5
Date	Tea	Coffee	Soda	Water
2020/11	12	35	7	81
2020/12	15	33	9	81

Why is that?

Could you help me please? Thanks!

[afv2688 · Accepted solution]

Hello @Stanislaw ,

go to the developer tools, there you will find one called dynamic rename.

On the configuration window select the option 'take field names from first row of data' and you will be done 🙂

Regards

[Stanislaw]

Oh my, so easy. Thank you.

I tried the tool before, but saw two inputs and it confused me and I left. 🙂