Dynamic Column Name Using Data in 2 Rows

sanketkatoch05

Hello, 

I'm looking for a specific type of output, wherein, the first two rows get merged into one using concatenation, and then they are converted into column headers. 

PS: The dates are random and are not in any specific order. 

Check out the files below. 

First is the input file, 

The second is the desired output file. 

PS2: This data does not have any headers, I want to take the header from the row which has the concatenated data (marked in blue which is either the first row or the second row. 

Thank You.

Luke_C

Hi @sanketkatoch05 

Understood, here's a solution that should be totally dynamic. Hopefully this solves the challenge!

New Workflow10.yxmd