вы уж определитесь, что вам надо - первоначальное решение в #14 если надо как-то по-другому потрудитесь сделать нормальный пример того, "что надо"прохожий2019
from = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content], nms = Table.ColumnNames(from), lst = List.Transform(List.Difference(nms,gr),(x)=>{x,f(x)}), tr = Table.TransformColumnTypes(from,List.Transform(nms,(x)=>{x,Text.Type})), rep = Table.ReplaceValue(tr,each [FeatureValue], each if [FeatureName]<>null and [FeatureValue]=null then "" else [FeatureValue] ,Replacer.ReplaceValue,{"FeatureValue"}), to = Table.Group(rep,gr,lst) in to
from = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content], nms = Table.ColumnNames(from), lst = List.Transform(List.Difference(nms,gr),(x)=>{x,f(x)}), tr = Table.TransformColumnTypes(from,List.Transform(nms,(x)=>{x,Text.Type})), rep = Table.ReplaceValue(tr,each [FeatureValue], each if [FeatureName]<>null and [FeatureValue]=null then "" else [FeatureValue] ,Replacer.ReplaceValue,{"FeatureValue"}), to = Table.Group(rep,gr,lst) in to