I am trying to set up a monthly report flow using Power Query.
I have 30csv files with sales data in each (Item Name | Sale Count | Total Value Sold, etc.) for every day of the month.
What I am trying to achieve is to combine them all together with the following template:
First line: April 1, April 2, ....
Second line: Item A 5 12 .....
Previously I have done that manually combining all item names together into one column, then removing duplicates, and afterwards using vlookup matching the item names to a corresponding sale count #, however, it proved to be very complicated and eats a lot of time. Is there a way to optimize Power Query functions to do that for a set of files? The most confusing aspect is how to combine data horizontally (not append vertically); and how to have only unique names when appending together.