excel ninjas

Scouse

Giant Thundercunt
FH Subscriber
Joined
Dec 22, 2003
Messages
36,629
How do I do this?

1725909767572.png

I've got lots of values in a column (about 20,000 of 'em) and they also have multiple values attributed to them o a separate row in that column.

I want to take them so I've only got a single value (A, B or C) and whack the corresponding rows into a single box, comma separated.

WILL TAKE PARTIAL WINS! :D

E.G: Value A in a column and then A1,A2,A3 in separate columns (I can concatenate) :)
 

Overdriven

Dumpster Fire of The South
Joined
Jan 23, 2004
Messages
12,751
How do I do this?

View attachment 49467

I've got lots of values in a column (about 20,000 of 'em) and they also have multiple values attributed to them o a separate row in that column.

I want to take them so I've only got a single value (A, B or C) and whack the corresponding rows into a single box, comma separated.

WILL TAKE PARTIAL WINS! :D

E.G: Value A in a column and then A1,A2,A3 in separate columns (I can concatenate) :)

1725953059284.png

To keep you from typing:
=UNIQUE(A2:A14)

=TEXTJOIN(", ", TRUE, FILTER($B$2:$B$14, $A$2:$A$14=D2))

1725953087529.png
 

Scouse

Giant Thundercunt
FH Subscriber
Joined
Dec 22, 2003
Messages
36,629
Gonna try that out now, ta.

It's a Brave New World and it's about time I got with the programme eh?
 

Overdriven

Dumpster Fire of The South
Joined
Jan 23, 2004
Messages
12,751
Gonna try that out now, ta.

It's a Brave New World and it's about time I got with the programme eh?

It took me longer to phrase the request than put the data into Excel :| So yes.
 

Scouse

Giant Thundercunt
FH Subscriber
Joined
Dec 22, 2003
Messages
36,629
Well it worked fucking brilliantly. Thanks :)
 

Users who are viewing this thread

Top Bottom