Forum Discussion
BjornK91
Jul 22, 2020Copper Contributor
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 ...
BjornK91
Jul 23, 2020Copper Contributor
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.
Jul 23, 2020
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