Forum

Need to combine mul...
 
Notifications
Clear all

Need to combine multiple excel files in a slightly different format

4 Posts
3 Users
0 Reactions
139 Views
(@pkantorgmail-com)
Posts: 2
New Member
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
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

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
(@pkantorgmail-com)
Posts: 2
New Member
Topic starter
 

HI Please find the files I made examples what I would like to do. 

 
Posted : 30/06/2020 2:54 pm
(@mynda)
Posts: 4761
Member Admin
 

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
Share: