Ungroup rows in Excel

[PAD]

Hi @andrey-mironov-96,
Have to tried combining e.g. the solutions discussed in the below threads?

How to split datatable into several datatables based on 1 unique key

Hi guys, I’m looking for suggestions of how to split a datatable into more datatables dynamically based on 1 key(ID) in the table. My initial datatable look like this: ID VARIANT 850 85 850 95 850 100 1107 20 1107 30 1107 40 1107 50 And I want to split each ID into a new datatable: Name of Datatable: 850 ID VARIANT 850 85 850 95 850 100 Name of Datatable: 1107 ID VARIANT 1107 2…

Writing datatable to excel file

Hi , Can anyone please let me know , how to write the data table to excel file and save it

Do they solve your issue?