grouping by store

[jcastr02]

Hello I'm trying to join or group by so that the information is grouped into the same record line.  See below current vs. Desired result.

Current		DESIRED RESULT
Store	Temporary Support Reason		Store	Temporary Support Reason
6244	Internal Store Closure		6244	Internal Store Closure; Project ABC
6244	Project ABC

[jcastr02 · Accepted solution]

Hello @olgad -  What option did you pick to group by here? All rows, etc.  did you manually change the formula?

[olgad · Accepted solution]

you can take any option max, min and then replace the part in the formula bar starting with each and before the type each Text.Combine([Temporary Support Reason], ";")

[olgad]

Hi, 
in power query

= Table.Group(#"Changed Type", {"Store"}, {{"Temporary Support Reason", each Text.Combine([Temporary Support Reason], ";"), type nullable text}})

[jcastr02 · Accepted solution]

Hello @olgad -  What option did you pick to group by here? All rows, etc.  did you manually change the formula?