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.
Solved! Go to 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
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.
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