Forum Discussion
PowerQuery: Combine files & Unpivot
Dear all, For one of my market analysis projects I'm looking for someone with a bit more experience with Power Pivot and Power Query in Excel. I have been able to successfully combine separate ...
ExcelExciting
First of all: thanks for your prompt response, really appreciate it that you're trying to help! 🙂
As for your follow-up questions:
1. Yest I'm combining the files via the folder.
2. I've added two different sample files, which I'd like to combine into the query result sample.
So basically the powerquery should combine the unpivoted files and use the dates from the column names as date values in the rows, along with the SKU and the value for that period.
Hi BjornK91,
What feel might be unpivot step is incorrect, should be unpivot other columns
if still you are facing the issue can you please attach your query file, I need to see the step where the issue is happening.
Regards, Faraz Shaikh