Text.Remove错了，直接移除“元”不就可以了，你这样的结果还有个小数点在，所以错了

这个周数，你最终想得到什么样子呢？

取字段，合并，去重

let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
转换 = Table.Combine(Table.AddColumn(源,"a",each Table.Transpose(Table.RemoveColumns(Table.Group(Table.FillDown(Table.AddColumn(Table.AddIndexColumn(Table.FromColumns({Text.ToList([数据])}),"序号",1,1),"判断",each if Text.Contains(Text.Combine({"A".."Z"}),[Column1]) then [序号] else null),{"判断"}),"判断",{"b",each Text.Combine([Column1])}),"判断")))[a])
in
转换

let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
自定义1 = Table.Group(源,"产品编号",{"a",each Table.Transpose(Table.FromColumns({List.Transform(Table.Group(Table.AddColumn(Table.RemoveColumns(,"产品编号"),"期间",each Date.DayOfYear([销售日期])-Date.DayOfYear([上市日期])+1),"期间",{"b",each },0,(x,y)=>Number.From(Number.RoundUp(y/7)<>Number.RoundUp(x/7)))[b],each List.Sum([成交金额]))}))}),
自定义2 = Table.FromColumns({Table.ToColumns(自定义1){0}}&Table.ToColumns(Table.Combine(Table.ToColumns(自定义1){1})),{"产品编码"}&List.TransformMany({1..Table.ColumnCount(Table.Combine(自定义1[a]))},each {null},(x,y)=>"第"&Text.From(x)&"周"))
in
自定义2