怎么批量将数量不一致的横向变成纵向，且纵向与横列数据保持对应，如图所示 ...

祥兴服装杨祥林

强！威武大佬！强！威武大佬！

国宝森

强！威武大佬！强！威武大佬！

沧笙

J2=INDIRECT("R"&SMALL(IF($B$3:$H$6>0,ROW($3:$6)),ROW(A1))&"C1",)
K2=INDIRECT("R2C"&(RIGHT(SMALL(IF($B$3:$H$6>0,ROW($3:$6)*1000+COLUMN($B:$H)),ROW(A1)),3)),)
L2=INDIRECT(TEXT(SMALL(IF($B$3:$H$6>0,ROW($3:$6)*1000+COLUMN($B:$H)),ROW(A1)),"R0C000"),)

罗旭东

J2=INDIRECT("R"&SMALL(IF($B$3:$H$6>0,ROW($3:$6)),ROW(A1))&"C1",)
K2=INDIRECT("R2C"&(RIGHT(SMALL(IF($B$3:$H$6>0,ROW($3:$6)*1000+COLUMN($B:$H)),ROW(A1)),3)),)
L2=INDIRECT(TEXT(SMALL(IF($B$3:$H$6>0,ROW($3:$6)*1000+COLUMN($B:$H)),ROW(A1)),"R0C000"),)

蔡玉环

[em01