Forum Discussion
Trying to combine multiple pricing guides into a power pivot
Perhaps you are corrct on pivot query. My strengths are not spreadsheets or Excel period. I just want to combine them all with 5 headers for all. The descriptions are good, and yes prices can change month to month. I need something so when i go in and redo our POS system, i know which tier our top 50 liqours should be inmathetes
I agree with mathetes , Power Query is more suitable and the logic of combining shall be defined first. Majority of us is not familiar with this business logic, even if the take a drink from time to time. There are Unit price, Case prise, CS price, qty deal, price by date, etc. - how to merge all that.
As for the technique, perhaps most logical is to place all these files in separate folder and Power Query them from master file. As soon as new file appears put it in that folder replacing previous one and Refresh All.