|
PQ
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
按分隔符拆分列 = Table.ExpandListColumn(Table.TransformColumns(源, {{"线路", Splitter.SplitTextByDelimiter("/", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "线路"),
按分隔符拆分列1 = Table.ExpandListColumn(Table.TransformColumns(按分隔符拆分列, {{"参数", Splitter.SplitTextByDelimiter("/", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "参数")
in
按分隔符拆分列1
多条件分列转置.rar
(27.11 KB, 下载次数: 10)
|
|