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.
Solved! Go to Solution.
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.
Understood, here's a solution that should be totally dynamic. Hopefully this solves the challenge!