PDA

View Full Version : Consolidating text cells



Jewels
2021-03-08, 08:43 PM
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
2021-03-09, 08:53 AM
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
2021-03-09, 09:12 AM
Look at the last example in this link https://www.howtoexcel.org/tutorials/concatenate-data-with-line-breaks/#:~:text=Conclusions-,Concatenate%20with%20Line%20Breaks%20Using%20the%20Ampersand%20Operator,when%20used%20in%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
2021-03-09, 04:11 PM
yes it would!