Forum Discussion

Amar-Agnihotri's avatar
Amar-Agnihotri
Resolver I
4 years ago
Solved

How to get data in pivot table format from multiple excel sheets using Power Query?

Hi All, I am having 5 excel files Sales_2017, Sales_2018, Sales_2019, Sales_2020,Sales_2021 and each excel is having this format of data    The customer Name may be same in any of the files ...
Need Help
  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    4 years ago

    Hi Amar-Agnihotri ,

     

    Step1 - Append all five files.

    Step2 - Unpivot all the value columns (i.e. 2017 - 2021). You will get "Attribute" and "Value" columns

    Step3 - Pivot the "Attribute" column

     

    Regards

    KT

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
4 years ago

Hi Amar-Agnihotri ,

 

Step1 - Append all five files.

Step2 - Unpivot all the value columns (i.e. 2017 - 2021). You will get "Attribute" and "Value" columns

Step3 - Pivot the "Attribute" column

 

Regards

KT