Forum Discussion
Transposing Data
Hi All, I have seen other posts regarding transposing rows and columns, but none that match my specific circumstance. The current structure of my data table is as such: Column 1 Column 2 C...
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:
Anonymous So what would the final result look like fully from the example given?