need output as required

[lvprasad]

i have data in below format.

i required the above data as in below format.

Can any one suggest me a solution.

attached the sample data.

[afv2688 · Accepted solution]

Hello @lvprasad,

is this ok for you?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[lvprasad]

Thank you so much @afv2688.

It's a perfect output. you helped me a lot. more over, i appreciate the way you think to get the solution.

[afv2688]

Hello @lvprasad,

I just noticed that your data is ordered in by Account and that within the account the data is ordered by the fields, so all I had to do is to get to append them using the same order.

That actually how I came to the solution you are able to see. Once I detect a pattern I try to think of the most efficient solution.

Regards