Forum Discussion

Medmanage101's avatar
Medmanage101
Frequent Visitor
5 years ago
Solved

Smartsheet Form - Data is Horizontal. Help!

After I created my Smartsheet Form (a Yes/No Questionaire with 120 questions), I noticed my data appears horizontally across the page.  Power BI does not know what to do with this information as it c...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Medmanage101 In Power Query, select site and object column, right-click, unpivot other columns, and you will attribute and value which you rename further.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ā¤ Kudos if my solution helped. šŸ‘‰ If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    āš”Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.āš”

parry2k's avatar
parry2k
Super User
5 years ago

Medmanage101 In Power Query, select site and object column, right-click, unpivot other columns, and you will attribute and value which you rename further.

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ā¤ Kudos if my solution helped. šŸ‘‰ If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

āš”Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.āš”