Sep 17 2024 02:42 AM
Hi. I have 2 big tables.
In 1 18251 lines like this
In other I want to get like this
How to do it?
Please)
Sep 17 2024 03:54 AM
@Apelsinka25
Let's say the first table is in A2:B18252 (with headers in row 1).
In D2, enter the formula
=UNIQUE(A2:A18252)
In E2, enter the formula
=TEXTJOIN(";"; TRUE; FILTER($B$2:$B$18252; $A$2:$A$18252=D2))
Fill down.
Sep 17 2024 06:28 AM
