Ungroup rows in Excel

[andrey-mironov-96 (Andrey)]

Hello dears!
There is a table in Excel, for example Example.xlsx (8.7 KB)
It is necessary that all lines with identical values in the column, for example Mark were saved in one Excel file, lines with Mike value were saved in other file, i.e. it is necessary to filter lines on unique value in the name column and to save all in different files (to Ungroup on files), I hope clearly exp

[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?