Hello,
I have data as below screen shot which is in columns but I want to transfer to be into rows.
In my example Item no 62232 (first row header product) is linked to 60755 and 62517 which are in columns F and H. Likewise 61387 (3rd product header product) is linked to 61008, 60524 and 60651 which are in F, G & H.
I would like to create a data table which has the header product in a column with a list in the next column of the linked products E.G
62332 60755
62332 62517
61387 61008
61387 60524
61387 60651
I don't mind if i have blank spaces as some headers have different no's of items linked to them.
I tried using pivot tables but it just replicated my table.............
I have data as below screen shot which is in columns but I want to transfer to be into rows.
In my example Item no 62232 (first row header product) is linked to 60755 and 62517 which are in columns F and H. Likewise 61387 (3rd product header product) is linked to 61008, 60524 and 60651 which are in F, G & H.
I would like to create a data table which has the header product in a column with a list in the next column of the linked products E.G
62332 60755
62332 62517
61387 61008
61387 60524
61387 60651
I don't mind if i have blank spaces as some headers have different no's of items linked to them.
I tried using pivot tables but it just replicated my table.............