July 1, 2021
Hi Everyone,
I am enclosing herewith a text file which I would like to convert as a Final Output as per the sample attached using Power Query.
I would really appreciate for any help in this matter
Thanks in advance.
Rashid
Trusted Members
Moderators
January 31, 2022
Trusted Members
Moderators
January 31, 2022
July 1, 2021
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.
Trusted Members
Moderators
January 31, 2022
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.
Answers Post
1 Guest(s)