Hi.
I am trying to unpivot a dataset, where I have multiple tables (one for each country) one below the other.
Each table has data for 5 products (same across countries) and the monthly sales for each is in their respective columns.
What i need is to have the following as columns - country, product, month and sales.
Have added an example of the source data and the desired format in the attached excel file.
Can someone help with this?
Thanks
Tarun
Please try adding the file again as it didn't come across. This time, don't forget to press "Start upload" before submitting your reply.
But perhaps you can fix it yourself with the suggestions/tips below.
So, all your tables have columns for Country, Product, Month1, Month2, Month3 etc.
First, connect to all 5 tables and append them to create one larger table. Then select the Country and Product columns. Right-click and select Unpivot other columns. That should return a table with 4 columns. Country, Product, Attribute (for the months) and Value (for the sales figures). Rename the last two to your liking and set the correct data types.
Download Unpivot-Use-Case.xlsxDownload Unpivot-Use-Case.xlsxDownload Unpivot-Use-Case.xlsxDownload Unpivot-Use-Case.xlsx
Uploaded the file again.
The country wise tables are placed one under the other on the same sheet.
Ah, I see. The data wasn't as I thought it would be. It requires a few more steps the create separate columns for Country and Product. I've added a query that does just that. See attached.
