We can achieve this using AddDataColumn in ForEachRow loop.
First, create DataTable for storing result. Next add a DataRow to store result data.
Then, In ForEachRow loop for source DataTable, add DataColumn to result DataTable by each row and set data to added column.
However, I have a Data Table already. Its an Extract Data Table. The results are stored in variable ExtractdataTabel.
The data table has ONE Column, and multiple rows. The Rows can be anything from 1 row, to 50 rows max. The row will vary depending on the Extract.
How would incorporate your solution with a pre-existing DAtatable using the Tabel Extraction Activity
If I use you example, would I have to Build a data table with 50 Rows. I understand it would ignore the nulls.
In your example though, the {} in the add data column, does not seem to function. It returns a n error that the array is larger than the rows in the table. OF course, is does not say which rows or which tables.