data manipulation

Hi,
I have a dataset like as below,
dataset

But I need to convert to anothor format as below,

I cannot find suitable skills to fulfill my target. Could somebody can give me some suggestions? Thanks.

BR,
Reg

Hi there!

I have achieved above with using Lag Column node which I used 6 times. Probably not the best solution but it works :slight_smile:

Workflow is attached. If you have any questions feel free to ask.

Table conversion.knwf (20.5 KB)

Br,
Ivan

Hi Ivan,
I like your solution, thanks!

BR,
Reg