Report: grouped by rows & columns (is this possible?)

Greetings everyone - report builders especially, I have a batch of survey responses (Answer Text) and I'd like to view them grouped by users (rows) & questions (column headings). Is this possible to...

Charting

excel

SergeiBaklan

Diamond Contributor

Jun 01, 2021

stevep17

If with legacy formulas for such model

in F3

=IFERROR(
  INDEX($B$3:$B$22,
        AGGREGATE(15,6,
            1/(COUNTIF($F$2:F2,$B$3:$B$22)=0)/
              ($B$3:$B$22<>"")*
            (ROW($B$3:$B$22)-ROW($B$2)),1)),
"")

drag down till empty cells appear

in G2

=IFERROR(
  INDEX($C$3:$C$22,
    AGGREGATE(15,6,1/(COUNTIF($F$2:F$2,$C$3:$C$22)=0)*
        (ROW($B$3:$B$22)-ROW($B$2)),1)),
"")

drag to the right

in G3

=IFERROR(
   INDEX($D$3:$D$22,
     MATCH(G$2,
        INDEX($C$3:$C$22,MATCH($F3,$B$3:$B$22,0)):
        INDEX($C$3:$C$22,ROWS($C$3:$C$22)),0)+
     MATCH($F3,$B$3:$B$22,0)-1),
"")

drag down and to the right.

QA transpose.xlsx12 KB