excel中如何将Sheet1 横向数据在Sheet2中竖向显示Sheet1假设Sheet1表结构如上图Sheet2Sheet2!A2单元格公式=IF(INDEX(Sheet1!$1:$3,COLUMN(A$1),ROW($A2))="","",INDEX(Shee
2022-10-20
excel中如何将Sheet1 横向数据在Sheet2中竖向显示Sheet1假设Sheet1表结构如上图Sheet2Sheet2!A2单元格公式=IF(INDEX(Sheet1!$1:$3,COLUMN(A$1),ROW($A2))="","",INDEX(Shee
2022-10-20