Feb 05 2021 02:36 AM
I need help getting the correct layout from a CSV file, i have attached an example file, with one side been the CSV format, and a wanted output.
The csv goes for over 800 lines, so dont want to do it manualy.
Hope there are someone out here that can help me :)
Feb 05 2021 03:10 AM
Here is an example file with two options.
Import and Export.
Only the details should be better adapted to your needs,
I would be happy to know if I could help.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Feb 05 2021 03:23 AM
Thank you for trying to help. But might be that i was unclear, or that I dont get your to work as intendend. (i just got it to import, that part I can handle, and the export macro (not sure what its supposed to do) I dont get to work)
Feb 05 2021 08:26 AM
@Jorekstad I see you tried it with Power Query. See attached for a working example.
Feb 05 2021 08:54 AM
Feb 05 2021 09:06 AM
@Jorekstad I took your example data, made a structured Excel table of it (called Table1) and connected to it with PQ. As long as you create a table with all your data in a structured table with the same name, the query will work. But better to connect to the CSV file directly with PQ and then do your transformations. Are you familiar with PQ?
Feb 05 2021 09:09 AM
Feb 05 2021 09:29 AM
Solution@Jorekstad Perhaps start at the link below. It points to a set of articles that explain the basics. As it is explained, there's a learning curve, but once you get the hang of it, "the sky is the limit".
Feb 10 2021 03:20 AM
Thanks a lot for the help. Got it all as i wanted now with some reading on the link :)
Feb 05 2021 09:29 AM
Solution@Jorekstad Perhaps start at the link below. It points to a set of articles that explain the basics. As it is explained, there's a learning curve, but once you get the hang of it, "the sky is the limit".