Excel实现每两行转置

18832013018

excel批量将两行三列转置为三行两列，并竖排放置，求大佬指教！！

良良

H2=OFFSET($A$1,(INT(ROW(A3)/3)*2+COLUMN(A1)-2)^(COLUMN(A1)>1)-1,MOD(ROW(A1)-1,3)+1)，右拉、下拉。

zpy2

create temp table aa as select RowID old_rowid,fillna(村) 村,* from 填充转一维再转二维; cli_one_dim~temp.aa~3;
create temp table bb as select 村,属性,group_concat(数量,'</td><td>') 值 from aaunion group by 村,属性 order by old_rowid;
//select * from bb;
cli_merge_row~bb~1;

cnmlgb9998

PQ !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!