Forum Discussion
Need help with excel
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.
If so thats eactly what i wanted, but need it for a bigger sheet
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?
- not realy, havent used excel for any thing advanced before
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".