I want to combine columns with the same row value in a text file into one list.

I'd like to use the Apriori algorithm to do the association rule.

Like an image I want to make a list of Cat. values in the same row with the same ID.

For example, Cat with an ID of 1010000092170000. guitar, watch/jewelry [guitar, watch/jewelry] Like this

Please help me /