Hi Rashid,

Please try attaching the file(s) again. Don't forget to press "Start upload" before you submit your reply.

Riny

Dear Riny

I did.

Please see it if available now.

Thanks.

Thanks, but I don't really see how the txt file relates to the desired output.

Dear Riny,

Extremely sorry.

I attached a wrong sample txt file. Please find herewith the correct file,

The output file is a sample of the output required where you may find some companies missing but you will get the overall idea of the output required.

As this is done by manual copy and pasting so chances are there some records might be missing.

Thanks for your time.

The attached PQ solution isn't going to win a prize for being the most beautiful piece of art, but it seems to work. The last two columns with amounts agree to the Output file you sent earlier. The first, however, does not. Several larger amounts are missing the first digit(s).

Please check it carefully.

Dear Riny,

Thanks for your time and help.

I will check and come back to you.

Dear Riny,

Sorry for the late response. I was away from work just joined back and tested your solution.

Works great.

Thanks a lot for all your time and help.