Requesting help in parsing data in the same order

[Manjari]

Hi All, 

Requesting help in parsing data in the same order

I have 3 files: ABC, CBA, PQR they all have values not in the right order. 

The output should look like this

Company	Value	Value2	Value3	Value 4	Value5
PQR	0.9	0.8	0.6	0.7	0.1
CBA	0.1	0.2	0.4	0.3
ABC	0.7	0.8	0.3	0.2

[SergioCamposs · Accepted solution]

@Manjari_T

I got this result:

Maybe it can help you.

See you : )

[Manjari]

Hi @SergioCamposs 

Thank you for helping me out. Apologies for the late reply I was out of station due to a family emergency.