Using Power BI with output from Forms

[davidbmitchell]

I am taking an output from Micrsoft Forms via Excel into Power BI. The output is a survey and that looks like TABLE A) and I need to create a visual like TABLE B)

TABLE A

Event	Attendee 1	Attendee 2	Attendee 3
EVT1	Good	Poor	Average
EVT2	Average	Poor	Average
EVT3	Poor	Good	Poor

TABLE B

Event	Poor	Average	Good
EVT1	1	1	1
EVT2	1	2	0
EVT3	2	0	1

How is this done?

Thanks

[v-yuta-msft · Accepted solution]

@davidbmitchell ,

In power query, click on [Attendee 1], [Attendee 2] and [Attendee 3], then click Transform-> Unpivot Columns, you will acheve the table as below:

 

Then click [Value] and click Pivot Column as below, you will achieve the expected table:

 

The result is as below:

Regards,

Jimmy Tao