Convert multiple columns into single column

I have been facing an issue in presenting the multiple select answers (having multiple columns in the excel) such as question having Options A,B,C & D. We can select multiple options. I am not able to plot this data in a single chart (let’s say bar chart) in the looker studio as we have different columns for each option in the excel and we require 1 column to club all the options. Do we have any way-out?

0 0 495
0 REPLIES 0
Top Labels in this Space
Top Solution Authors