自定义1 = List.Transform(Table.ToRows(源),each List.RemoveNulls(_)),
自定义2 = Table.Combine(
List.Transform(自定义1,
each Table.FromColumns(
{ {_{0}} } &
List.Zip(
List.Transform(
{1..(List.Count(_)-1)/2},
(x)=>List.Range(
_,
x*2-1,
2
)
)
)
)
)
)