How to move repeated text from a column in excel to another sheet

Hi,

I’m a beginner in Uipath.
I have a sheet in excel with a column where the text is dynamic. My question is how I can sort out repeated, or not repeated, text from this column and move it to a column in another sheet?

For example:
Sheet 1
Apple
Apple
Banana
Melon
Melon

I want the result to be like this:
Sheet 2
Apple
Apple

Sheet 3
Banana

Sheet 4
Melon
Melon

The text is dynamic, so I don’t know if the words are apple, banana, melon or something else. Nor how many of each.

1 Like

Hi @ErPed

This is doable you just need to group it and retrieve it using the group data and pass it to datatable and write it to the excel .

cheers :smiley:

Happy learning :smiley:

@ErPed

Welcome to the uipath community.

Please check below thread and follow the steps mentioned by me @lakshman

Filter records based on dynamic column values