Skip to Content
0
Aug 02, 2023 at 12:54 PM

How to separate multiple items from single dimension into multiple columns

65 Views

Hi.

In my universe i have a field for a reference number assigned to a single person.

This single person can have multiple products.

I have my table pulling back all the relevant data however when i get the data back it makes a new row entry for each time they have X product.

So row 1 is 123456 with a product of XYZ and then second row 123456 with a product of ZZZ until all their products are done and then continues to the next user reference.

I need to split my product so that it displays a new column for when a new product is matched. So i need 1 row to contain the reference number and multiple columns with product 1, product 2, product 3 etc. There are hundreds of products so cant just filter easily.

Any help is appreciated guys.