Excel Transpose row to column

[ppr (Peter Preuss)]

will match the explanation, what we gave for the case

@ppr

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

Show us your XAML and what was modelled so far at your end. Thanks