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 RESULTStoreTemporary Support Reason StoreTemporary Support Reason6244Internal Store Closure 6244Internal Store Closure; Project ABC6244Project ABC

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

Forum Discussion

Post Prodigy

2 years ago

Solved

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
2 years ago
Hello olgad - What option did you pick to group by here? All rows, etc. did you manually change the formula?
olgad
2 years ago
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
Resident Rockstar
2 years ago
Hi,
in power query

= Table.Group(#"Changed Type", {"Store"}, {{"Temporary Support Reason", each Text.Combine([Temporary Support Reason], ";"), type nullable text}})
- jcastr02
  Post Prodigy
  2 years ago
  Hello olgad - What option did you pick to group by here? All rows, etc. did you manually change the formula?
olgad
Resident Rockstar
2 years ago
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], ";")