Data Table Transfromation

[csprch]

Hi, 

I have a data table with multiple headers and I intend to transform the data to look like the photo attached. 

I have trouble generating repeating rows for the headers which is where im currently stuck at. 

The data i start with looks like this: 

and I would want the data to have this layout:

(with the values instead of null).

Can anyone guide me in the right direction? Thank you very much! 

[DanielMS · Accepted solution]

Hi @csprch,

I have attached a workflow that solves your problem.

Thanks

Dan

[JosephSerpis]

Hi @csprch I mocked up a workflow that produces the output you describe. Not the most clean solution but let me know what you think?

[JoeS]

Seeing as I started as well and then got distracted I too built it out.