Transpose data in new format

[sriniprad08]

Hi Team,

Hope you are well. I need help. 

Currently i have the many files with as shown in the attached file as input. I need to have one output shown in the file.

Thanks for the help.

Sri

[IraWatt · Accepted solution]

Hey @sriniprad08,

Not sure if I understand the question. Do you just want to take the first and second line of data and join them to make the output?

[binuacs · Accepted solution]

@sriniprad08 Another way of doing this with Union tool and the summarize tool

[sriniprad08]

Hi @binuacs ,

Thank you so much for the help. Appreciate it.

Cheers,

Sri

[sriniprad08]

Hi @IraWatt ,

Thank you so much for the help. Appreciate it. Actually I would like to have the month data next to each other.

Cheers,

Sri