I'm trying to mimic a pivot table behaviour where you would grab all distinct values from Col B and, by each of those unique Col B values, you associate all each respective values, that must also be distinct by each unique Col B.
Here's my data set:
A B y_13_other 4601032322-video y_13_other 4601032322-video o_06_other 4601032322-video1 o_06_other 4601032322-video o_06_other 4601032322-video2
The final result should be:
B A 4601032322-video y_13_other 4601032322-video o_06_other 4601032322-video1 o_06_other 4601032322-video2 o_06_other
I've tried the query with
Group by, but it doesn't seem possible to aggregate by text.
=QUERY(A2:B5;"SELECT A,B group by B")
This would need an AGG, and it only seems to work with numbers.
Another option I thought was to pair a query with
vlookup, but I haven't managed to, is there a way to do this, even without the query formula?
Note: I don't know how many rows A or B is going to have and don't know their future names, it would have to work dynamically.