Transpose Table

[Danilão]

Good afternoon, everyone.
I got this formula from an old article on another website, but it's causing problems.

Could someone help me?

 

[MikeVol]

=IFERROR(
    OFFSET(
        $A$5,
        SMALL(
            IF(($B$6:$D$9<>"")*(COLUMN($B$6:$D$9)=MATCH(G6,$B$5:$D$5,0)+1),
                ROW($B$6:$D$9)-5
            ),
            COUNTIF($G$6:G6,G6)
        ),
        MATCH(G6,$B$5:$D$5,0)
    ),
"")

 

[p45cal]

Since you're now using a version of Excel at least version 2016 then you can use Power Query to do this. See table at cell J14 of the attached. Should you change the table at A5 you'll need to refresh the table at J14 by right-clicking somewhere within it and choosing Refresh.

 

[Danilão]

=IFERROR(
    OFFSET(
        $A$5,
        SMALL(
            IF(($B$6:$D$9<>"")*(COLUMN($B$6:$D$9)=MATCH(G6,$B$5:$D$5,0)+1),
                ROW($B$6:$D$9)-5
            ),
            COUNTIF($G$6:G6,G6)
        ),
        MATCH(G6,$B$5:$D$5,0)
    ),
"")

Thanks a lot, Mike !
Exactly that.

 

[Danilão]

Since you're now using a version of Excel at least version 2016 then you can use Power Query to do this. See table at cell J14 of the attached. Should you change the table at A5 you'll need to refresh the table at J14 by right-clicking somewhere within it and choosing Refresh.

Thanks p45Cal .