Forum Discussion

Liaise's avatar
Liaise
Frequent Visitor
7 years ago
Solved

Reformatting table/data structue

Hi,   I'm hoping someone can help. I have a table that contains survey results and I was wondering if there is some way I can format the data in the example below   tblSurveys Customer     Quest...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi Liaise 

     

    In The Query Editor>>> select the Question Column>>>Go to "Transform Tab">>Select "Pivot Table"

     

    Select options as follows

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Hi Liaise 

 

In The Query Editor>>> select the Question Column>>>Go to "Transform Tab">>Select "Pivot Table"

 

Select options as follows

 

Liaise's avatar
Liaise
Frequent Visitor
7 years ago

Thanks, that works perfectly :)