I have a excel containing many different ID, how can I put each ID into a new sheet?
I have attached excel for reference, sheet 1 is input and other sheets are expected result.
Please noticed that actually I won’t know how many ID will be contained in sheet 1, therefore I wont know how many worksheets should I create.
In case, maybe finally it only contains 2 different ID or contains 100 different ID.
Many thanks.testing.xlsx (13.7 KB)