Populate new data table by headers

[Povilas_Jonikas]

Hello guys. I have a data table like so:

I need to transpose this table. The rows “Data” and “Data1” could be the separators. Basically, Collumn A should be the headers, and Collumn B should be the data of the headers. How can I achieve that?

Note: The headers are not always the same, sometimes there may be more headers than usual and sometimes less.

[ppr (Peter)]

A few options:

• dynamic generating the columns (from A Col) and populating it (with B Col)
• JSON Jarray From Dictionary toObject DataTable Trick

[tazunnisa.badavide (Taj)]

DataTable_To_ExcelHeaderValues.xaml (10.7 KB)
Hope this might help you @Povilas_Jonikas

[ppr (Peter)]

@ppr

JSON Jarray From Dictionary toObject DataTable Trick

find some starter help:

[Povilas_Jonikas]

Thanks guys, ill try both in a bit and let you know