Transform Header description dynmaic

Hi Community Team,

I get weekly sales data (for the past 26 weeks) in attached format with weeks header description.

I need to find a way to have the header changed for always the oldest week like "Sales WK1" etc--> see green headers.

In addition, I need to create a new column which just repeats the "sales weeks used" like: 34.2020-06.2021

+ a column with the Avr.Abs.Dev per line.

Do you have any suggestion how do to that the most sufficient way?

Thank you very much for your support in advance.

BR,

Pascal

Datasets

Accepted answers

Ah, of course.

Just put a Dynamic Rename tool at the end and select "Take Field Names from First Row of Data":

In tried to make this as dynamic as possible:

(I've only done the first five, you can do the rest!)

Hope this helps.

Thank you very much for your solution.

How can you now tell that the first row are the "new" headers?

BR,

Pascal