Populate new data table by headers

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.

A few options:

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

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

1 Like

find some starter help:


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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.