Consolidating text cells

Jewels

New member
Joined
Mar 8, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
365 excel pro
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
 

Attachments

  • example.xlsx
    9.2 KB · Views: 15

alansidman

Member
Joined
Oct 1, 2018
Messages
362
Reaction score
1
Points
18
Location
Steamboat Springs
Excel Version(s)
O365
Would a presentation as below be acceptable?

Excel 2016 (Windows) 32 bit
A
B
3
ActivityMeasure
4
452957Update 1 ,update 2 ,Update 3 ,Update 4
5
454050Update 1
6
454423Update 1 ,update 2 ,Update 3 ,Update 4 ,Update 5
7
454424Update 1 ,update 2 ,Update 3
Sheet: Sheet2


Achieved in Power Pivot with Measure created using ConcatenateX
 

Attachments

  • example.xlsx
    84.5 KB · Views: 11
Last edited:

alansidman

Member
Joined
Oct 1, 2018
Messages
362
Reaction score
1
Points
18
Location
Steamboat Springs
Excel Version(s)
O365

Attachments

  • example.xlsx
    84.1 KB · Views: 12

Jewels

New member
Joined
Mar 8, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
365 excel pro
yes it would!
 
Top