Excel Transpose row to column

[ppr (Peter Preuss)]

Cross reference:

Transpose excel data

Yes is possible as also indicated by others with Link sharings: For Excel: read in - without add Headers use first column - all rows as column names and construct a new datatable schema then iterate over all columns with colindex > 1 and use all row values as values For DataTable: in general same logic, we just set first column name with a default as it is the turning point Excel case (Modelling sample) Preparation [grafik] DataTable: an empty DataTable initialized with dtResult = ne…