Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
37
Views
Topic starter
I have multiple shops in various area's where I have my employees fill out excel spreadsheets on daily sales.
I have made a simple example of the 3 files which come to me and then a combined file which I would like to automate the process, which I currently do manually.
I am familiar with the Power query but I have not yet gotten proficient in it.
Can anyone assist
Posted : 29/06/2020 9:09 am
Hi Peter,
If you can attach those sample files we'll take a look at what we can do for you.
Regards
Phil
Posted : 29/06/2020 8:24 pm
Topic starter
HI Please find the files I made examples what I would like to do.
Posted : 30/06/2020 2:54 pm
Hi Peter,
Thanks for sharing your sample files.
You can use Power Query to get files from a folder. You'll need to edit the 'sample query' it generates and unpivot the data so that it's in a tabular format. It's a bit tricky to explain in the forum because there are lots of steps and it's easier to show in a video. If you get stuck, I recommend you take my Power Query course so you can get up to speed with it quickly.
Mynda
Posted : 30/06/2020 8:29 pm