Create dashboard with many duplicate collumns

[Anonymous]

Hi All, 

I have a set of data that is formed from 5 sheets. Within those 5 sheets there are multiple questions which are identical. They are for different types of vehicles but the same question needs to be asked across the different vehicles so the same collumns are created in Power BI. How do i go about displaying this data in a dashbaord. I have attached a snippet of the table view where a couple of rows have been inputted to test the microsoft form of which it has been populated from. I have also shows a snip of the data collumns too. As you can see duplicate questions but they are asked for the different types of vehicles e.e electric, combustion. I have a feeling i need to "bucket" the data but not sure where to start! Help haha. 

[Anonymous]

How do i do that sorry. 

[MFelix · Accepted solution]

On the Query Editor select all columns that are questions then on the transform select unpivot:

[MFelix]

Hi @Anonymous ,

The best option in this case is to select the columns with the questions and do Unpivot columns, this will give you a table with all the information about the vehicles and then two other columns attribute (question) and the value (answer) then you can do all type of visualizations you need by selecting the specific question.

[Anonymous]

I was wondering If i have to separate all the different questions into the 5 types of forms that the customer fills in. I.e. there are 5 sets of the same questions but it would be used for 5 different vehicles?

[MFelix]

There is no need because you have that information in the questionaire you just need to unpivot the columns,