PowerQuery中如何实现如下转置？

kenese

把处置意见和站点作为行，损失数量和完成日期作为行中对应列的值。


即附件中A1:H15  转置成A19:AB21

zpy2

//select * from Sheet1;
create temp table aa as
select f01,f02,f04,f06 from Sheet1;
cli_create_two_dim~aa~f04~f06;

create temp table bb as
select f01,f02,f07,f08 from Sheet1;
cli_create_two_dim~bb~f07~f08;
select * from aa_two_dim inner join  bb_two_dim using(f01,f02);

kenese

zpy2 发表于 2024-8-2 22:15
//select * from Sheet1;
create temp table aa as
select f01,f02,f04,f06 from Sheet1;

不用SQL,用户要用Power BI.

cnmlgb9998

这样。。。。。。。。。。。。。。。。。。。。。。

kirete