Hello,
I start to use powerpivot to solve one problem but still cant do it.
Lets say i have structure like this
Lp.| 1q | 1q
1| a | c
2| b | d
3| a | b
4| b | a
2,3 columns are the same question but there was option to mark 2 answers. Is it possible in powerpivot to combine them in 1 to use as pivot table.
For instance how many ppl selected b in 1 question (here is 3)
Best regards
I start to use powerpivot to solve one problem but still cant do it.
Lets say i have structure like this
Lp.| 1q | 1q
1| a | c
2| b | d
3| a | b
4| b | a
2,3 columns are the same question but there was option to mark 2 answers. Is it possible in powerpivot to combine them in 1 to use as pivot table.
For instance how many ppl selected b in 1 question (here is 3)
Best regards
