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)
DataTable: an empty DataTable initialized with dtResult = new DataTable
ColumnName = row(0).toString.Trim