Having data and want to have the same columns but need to combined some rows !

[aamara]

Hi, I have a huge data in excel with multi rows and columns. I want to regenerate the same data columns but some rows needs to be combined together based on the duplicated TXN no.

below an example of the requested:

Kindly assist me to have the data the same way i want.

 

[ravishankar]

example?
Ravishankar

 

[aamara]

I am not able to post the image of the example!

 

[sandy666]

create example excel file with source data and expected result
use onedrive, googledrive etc and post link to shared file here

 

[aamara]

here we go...

https://drive.google.com/file/d/1S5oweTw9HxJRGCoFXthj3nTyWlJnNMNy/view?usp=drivesdkhttps://drive.google.com/file/d/1S5oweTw9HxJRGCoFXthj3nTyWlJnNMNy/view?usp=drivesdk