Merge multiple string values into single list of values

Question

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

Sachin Singh · Answer

can be achieved easily with simple cross join, meaning a hooded shirt can be of any size and any given color so total combination is n*n*n public ActionResult abc() { List shirtTypes= new List (){ "Hooded Shirts" , "Oxford Shirts" , "Casual Shirts" , "Smart Shirts" , "Checked Shirts" }; List sizes= new List (){ "XXS" , "XS" , "S" , "M" , "L" , "XL" , "XXL" }; List colors = new List () { "Black" , "Blue" , "Brown" , "Cream" , "Green" , "Grey" , "Orange" , "Pink" , "Purple" , "Red" , "Stone" , "White" , "Yellow" }; var res = (from a in shirtTypes from b in sizes from c in colors select new Custome { shirtType = a, size = b, color = c }).ToList(); return View(res); } public class Custome { public string shirtType { get; set; } public string size { get; set; } public string color { get; set; } } @model IEnumerable @{ Layout = null; } "viewport" content= "width=device-width" /> abc @Html.ActionLink( "Create New" , "Create" ) class = "table" > @Html.DisplayNameFor(model => model.shirtType) @Html.DisplayNameFor(model => model.size) @Html.DisplayNameFor(model => model.color) @foreach (var item in Model) { @Html.DisplayFor(modelItem => item.shirtType) @Html.DisplayFor(modelItem => item.size) @Html.DisplayFor(modelItem => item.color) @Html.ActionLink( "Edit" , "Edit" , new { /* id=item.PrimaryKey */ }) | @Html.ActionLink( "Details" , "Details" , new { /* id=item.PrimaryKey */ }) | @Html.ActionLink( "Delete" , "Delete" , new { /* id=item.PrimaryKey */ }) }

peter · Answer

Thats good. Although i require unique column values to display once only! I know the relation by the extra ID column values,so i dont require a print out of all combinations when there could be a vast list. Thanks