peter

peter

  • 0
  • 89
  • 0

Merge multiple string values into single list of values

Jun 11 2021 12:59 PM

I have the following lists of values and want to combine them to create a table structure as shown below.

Hooded Shirts,Oxford Shirts,Casual Shirts,Smart Shirts,Checked Shirts

XXS,XS,S,M,L,XL,XXL

Black,Blue,Brown,Cream,Green,Grey,Orange,Pink,Purple,Red,Stone,White,Yellow

To the list i want to add an extra ID value also to build a single Product list.

list(of Products)

Output

ID   Name            Size        Colour
5 Hooded Shirts    XXS       Black
5 Oxford Shirts     XS           Blue
5 Casual Shirts     S             Brown
...
5  NULL                XL           Grey


Answers (2)