Forum Discussion

BjornK91's avatar
BjornK91
Copper Contributor
Jul 22, 2020

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 ...
excel
ExcelExciting's avatar
ExcelExciting
MVP
Jul 23, 2020

Hi BjornK91

 

Pls share the screenshot of your step, are you combining the query via folder ? If possible attached sample scenario with few records with your desired results manually place.  

 

Regards, Faraz Shaikh 

BjornK91's avatar
BjornK91
Copper Contributor
Jul 23, 2020

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.

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    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  

Resources