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?

Post Prodigy

2 years ago

Solved

grouping by store

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], ";")