Power Pivot - Error in Summary calculations with Cross tab for ABC, XYZ Analysis

Hi ExcelExciting 

Thanks. The challenge is to convert the cross tab information into the list so as to be able to upload into the Power Pivot or Power BI for subsequent analysis. I am not sure how it can be done. My actual files are quite huge with the 2000+ product sales across all the months in the year with sales qty in Kg and sales value in Euro in the cross tab fashion as I showed in the example file.  This transformation needs to be done for all the warehouses for all countries which come to be about 50+ files. I need to have a mechanism to automate transformation for all these files. 

I adopted one in-direct method which may not be the best

1. Copied and created an identical copy of the same file. Now I have two files of the same info

2. In the first file, I removed the Sales in Euro values and kept only the characteristics and Kg values

3. I unpivoted the Kg values and split the attribute column into two and separated the month and year information in one column. 

4. Similarly, I removed the Sales in Kg values from the second file and kept only the characteristics and Euro values

5. I unpivoted the Euro values and split the attribute column into two and separated the month and year information in one column. 

6. I added both the sheets into the model and linked them with Product ID. 

7. Now there are two tables but not sure it is the right way or not and gives the ABC, XYZ analysis. 

Experts, please suggest if there is any simpler way to do it.