Consolidating text cells

[Jewels]

Hello, I'm trying to consolidate cells into one cell using a common identifier. I was looking for something like sumifs for text but I have not found anything but Concat which you manually have to add each cell and the number of cells can change. This is pulling into a bigger report and a pivot table would not be helpful. I've tried Ifsums, If, Match index and concat. Please help

[alansidman]

Would a presentation as below be acceptable?

Excel 2016 (Windows) 32 bit

	A	B
3	Activity	Measure
4	452957	Update 1 ,update 2 ,Update 3 ,Update 4
5	454050	Update 1
6	454423	Update 1 ,update 2 ,Update 3 ,Update 4 ,Update 5
7	454424	Update 1 ,update 2 ,Update 3

Sheet: Sheet2

Achieved in Power Pivot with Measure created using ConcatenateX

[alansidman]

Look at the last example in this link https://www.howtoexcel.org/tutorials...%20a%20formula

Excel 2016 (Windows) 32 bit

	A	B
3	Activity	Measure
4	452957	Update 1 update 2 Update 3 Update 4
5	454050	Update 1
6	454423	Update 1 update 2 Update 3 Update 4 Update 5
7	454424	Update 1 update 2 Update 3

Sheet: Sheet2

[Jewels]

yes it would!