Ungroup rows in Excel

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 :sweat_smile:

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


Do they solve your issue? :slight_smile: