Forum Discussion
Solved
Need help with excel
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 d...
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".
Jorekstad I see you tried it with Power Query. See attached for a working example.
- How did you do this? Is it automaticly filling in from the first output into the wanted output tab?
If so thats eactly what i wanted, but need it for a bigger sheetJorekstad 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?
- not realy, havent used excel for any thing advanced before
