Forum Discussion
multiple rows into one row
Helloo
Here is the code : -
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"PostDate", type date}, {"ValueDate", type date}, {"Details", type text}, {"ChqNo", Int64.Type}, {"Debit", Int64.Type}, {"Credit", Int64.Type}, {"Balance", type number}}),
#"Filled Down" = Table.FillDown(#"Changed Type",{"Balance"}),
#"Grouped Rows" = Table.Group(#"Filled Down", {"Balance"}, {{"PostDate", each List.Sum([PostDate]), type nullable date}, {"ValueDate", each List.Sum([ValueDate]), type nullable date}, {"Details", each Text.Combine([Details], " - "), type nullable text}, {"ChqNo", each List.Sum([ChqNo]), type nullable number}, {"Debit", each List.Sum([Debit]), type nullable number}, {"Credit", each List.Sum([Credit]), type nullable number}})
in
#"Grouped Rows"
Hi chanpreet_90 ,
Delete the red and move them to blue. I won't try to sum date or cheque no.
#"Grouped Rows" = Table.Group(#"Filled Down", {"Balance", "PostDate", "ValueDate", "ChqNo"}, {{"PostDate", each List.Sum([PostDate]), type nullable date}, {"ValueDate", each List.Sum([ValueDate]), type nullable date}, {"Details", each Text.Combine([Details], " - "), type nullable text}, {"ChqNo", each List.Sum([ChqNo]), type nullable number}, {"Debit", each List.Sum([Debit]), type nullable number}, {"Credit", each List.Sum([Credit]), type nullable number}})
Regards
KT
Hey..
it worked but in balance column the value is repeating...
Regards