在PoweryQuery编辑器中转换数据

halosy · 发表于 2024-8-15 12:05

新手小白刚入PQ，请大佬帮忙看看如何处理

wofuocibei2008 · 发表于 2024-8-15 13:30

Table.FromColumns(List.Transform(List.Zip(List.Split(Table.ToColumns(Table.Transpose(源)),10)),each List.Combine(_)),{"1","2","3","4","5","6","7","8","9","10"})

127000 · 发表于 2024-8-15 15:07

=Table.FromRows(List.Split(源[列1],10),{"表头1","表头2","表头3","表头4","表头5","表头6","表头7","表头8","表头9","表头10"})

复制代码

halosy · 发表于 2024-8-15 15:53

wofuocibei2008 发表于 2024-8-15 13:30
Table.FromColumns(List.Transform(List.Zip(List.Split(Table.ToColumns(Table.Transpose(源)),10)),each ...

可以了，感谢大佬！

halosy · 发表于 2024-8-15 17:00

127000 发表于 2024-8-15 15:07

感谢大佬！好用~谢谢！

minchar · 发表于 2024-8-15 21:15

= #table({"表头1","表头2","表头3","表头4","表头5","表头6","表头7","表头8","表头9","表头10"},List.Split(Excel.CurrentWorkbook(){[Name="表1"]}[Content][列1],10))

halosy · 发表于 2024-8-16 18:00

minchar 发表于 2024-8-15 21:15
= #table({"表头1","表头2","表头3","表头4","表头5","表头6","表头7","表头8","表头9","表头10"},List.Spl ...

好用，谢谢！太感谢啦~

		自动登录	找回密码
密码			免费注册

[求助] 在PoweryQuery编辑器中转换数据