So I have a table consisting of 4 columns, i want to get all the data into 3 different columns and match their respective information while ignoring duplicates.
Any help on this please??
THANKS IN ADVANCE

MULTI COLOUMNS.JPG