Forum Discussion

bigdee008's avatar
bigdee008
Frequent Visitor
7 years ago
Solved

Unpivot Multiple Columns - Desktop

**total noob alert*    Is there a to unpivot multiple data in PBI desktop?    I have datasource = Excel which is has an unusable data structure. Table headers are shown transposed below: Im looki...
Need Help
bigdee008's avatar
bigdee008
Frequent Visitor
7 years ago

Thanks Greg.

 

 

So my situation is,  simply put;

 

currently, i have Colums A ,B, C, D1, D2, D3, E1, E2, E3 

 

I want to make the colums A, B, C, D, E. --  .i.e. all transaction data under D1 to D3 will go under D likewise for E1-E3 will go under E without losing their mapping.

 

Im so sorry If im not being clear enough :smileysad:

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I went ahead and took a stab at this. Here's the final output of what I did:

 

Not entirely sure if that is what you are looking for ( or maybe more of a step in the correct direction). If I understand you correctly, the next step would be renaming the Current Head with the New Header?

  • bigdee008's avatar
    bigdee008
    Frequent Visitor
    7 years ago

    Thanks a lot Nick and Greg, below screengrab shows the row 1 or my actual data set. Maybe that will shed more light on what im trying to accomplish. 

     

    I came across the EXACT same thing im trying to accomplish here in the link, however, im not sure how to modify the query utilized there: 

     

     

     

     

      • bigdee008's avatar
        bigdee008
        Frequent Visitor
        7 years ago

        Hello v-cherch-msft Thanks for the effort but to say that I  understand what your are suggesting, i would be lying. Again i have to wwarn that I am a complete noob. Can you share a little bit more detail?