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.

[sanketkatoch05]

Hey, 

I am actually looking for this output only, but the data 'A' and 'B' are dynamic. So, I don't think the renaming via Select tool would cater to my problem. 

[Luke_C · Accepted solution]

Hi @sanketkatoch05 

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

[sanketkatoch05]

Hey, @Luke_C .

Thank you so much for helping me out.