Transpose row, delete duplicate headlines and rename

[sebastianlauss]

Hey there.

I'm kind of confused how to start the workflow. 

My aim is to get a structure like the attached file.

If somebody give me advices or solutions it would be super kind. 

Thanks!

[Raj]

@sebastianlauss 
The data on the input sheet do not match there is more data in output sheet
hope you are looking for the help to get the column headers
if yes i can help with flow 
else please explain the challenge in detail.

[sebastianlauss]

Excuse me there went something wrong with the input data. Now it's fine. I edited and updated the file above.

The first row in the input is equal to the column "Kategorie" in the output. First I would like to transpose this like shown in the output column "Kategorie". Of course there are more rows in the output because there are less columns due to the "Kategorie" column.

.Secondly the headlines. The second row in the input are the real headlines. But there are a lot of duplicates because of the first header/row in the input. Therefore the transposition as mentioned before.

The headlines in the output are the same as the input but without the duplicates and the value "Limit" becomes " & (value from the cell left next to limit) & _Limit".

And yes I am looking to get the headers like mentioned now and to transpose the first row (input) to the column "Kategorie" (output).

I hope it's understandable now. Thank you @Raj 

[Felipe_Ribeir0 · Accepted solution]

Hi @sebastianlauss 

Try the attached workflow.

[Raj · Accepted solution]

@sebastianlauss 
find the workflow attached
hope this help.

[sebastianlauss]

Thank you very much both of you!

This helps a lot!