A Short post playing around with embedded tables in collections
Contents
Create an Single Column Embedded Table within a Collection
ClearCollect(
colA,
{
Month: [
"Jan",
"Feb",
"Mar",
"Apr",
"May",
"Jun"
]
}
)
Extract the Contents of the Table and place in a new Collection
Clear(colB);
ForAll(
colA,
Collect(
colB,
Month
)
) 
Give the Extracted Table Column a Name
ClearCollect(
colC,
RenameColumns(
colB,
"Value",
"Name"
)
) 
Return the Contents back to an Embedded Table
ClearCollect(colD,{Month:colC})ClearCollect(
colD,
{Month: colC}
) 