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.