Forum Discussion

Tevon713's avatar
Tevon713
Helper V
4 years ago
Solved

Convert single column to row

Hi.   I have table as follow, want to convert the "Account" as row. What is the best way to transform this? Thanks.   Current: Site # Year Month Account Value Site 1 2019 January Co...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Tevon713 ,

     

    I have not gotten to the post result you wished for, but here somethinng that maybe gets you closer to a solution:

     

    What I did was that I pivoted on the Account column using the Value column as value. To do this, mark the Account column and click on Pivot column in the transform section:

     

     

    What puzzles me is how you would want to return 200 for Site 1 in the Column Count2, since in your raw data Site 1 never has the attribute Count2. Same thing for Count3...

     

    Hope this helps you anyway 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

     

     

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Tevon713 ,

 

I have not gotten to the post result you wished for, but here somethinng that maybe gets you closer to a solution:

 

What I did was that I pivoted on the Account column using the Value column as value. To do this, mark the Account column and click on Pivot column in the transform section:

 

 

What puzzles me is how you would want to return 200 for Site 1 in the Column Count2, since in your raw data Site 1 never has the attribute Count2. Same thing for Count3...

 

Hope this helps you anyway 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

 

  • Tevon713's avatar
    Tevon713
    Helper V
    4 years ago

    Hi tackytechtom.,

     

    Thanks for your help. Sorry I typed up too quick. The result you showed is correct.