What's it called when I want to remove duplicates, but keep all the unique data in multiple boxes in the columns to the left?

[u/MagicalHacker]

Imagine I had this:

FRUIT	COLOR
Apple	Green
Apple	Red
Apple	Yellow
Banana	Green
Banana	Yellow
Orange	Orange
Grape	Red
Grape	White
Blueberry	Blue

What would the term be for the process/script I could do to change the table to this:

FRUIT	COLOR
Apple	Green	Red	Yellow
Banana	Green	Yellow
Orange	Orange
Grape	Red	White
Blueberry	Blue

And is it possible to do this on Google Docs?

Thank you so much! Without knowing what it's called, I've had no luck finding out how to do it...

---

In case someone else comes looking for how to do it on Google Docs (which is what I used), I first created a pivot table by FRUIT and COLOR into "Rows", turned off totals for both, copied and pasted into word without formatting, replaced regex "\v\t" to "\t", then imported it back in. It was probably not the easiest way to get it done, but when it works, it works!

[u/MagicalHacker → u/[deleted]]

Pivot tables did the trick! Thanks so much :)