need output as required

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.

Output

Accepted answers

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

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.