Forum Discussion
Transposing Data
I also shortened the steps (optimized, not much)
Anonymous Not 100% that this is what you want but see if the attached PBIX takes care of this.
Not quite. The next step would be to unpivot Column 3 thru Column 6 in Table 3 of your file. However, it does not produce the desired result as Prod Code 0123 should have monthly sales of 0, 1, and 2.
Anonymous So what would the final result look like fully from the example given?
Something like this (using the PBI sample you provided).
However the value portion is incorrect based off the sample data. The entries for prod code 123 should look like:
The issue stems from this: the first 3 rows have a unique structure where the first column is null, the second column is really a column header, and then each remaining column has 1st row Retailer ID, 2nd row Prod Code, 3rd row Product Description with all rows underneath representing the quantity sold for that unique item at the specified country and date in columns 1 and 2.
Anonymous So what would the final result look like fully from the example given?