Forum Discussion
multiple rows into one row
I have a data in this format and I want to combine the rows of Details into one row. please help me ...I am a beginner...I tried using Text.Combine but still getting error.. Thanks in adv...
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