Split data with same value

[Kjaer]

Hi

I have a dataset, which I want to split in to files. One file with data with same values and one files with the other values. Can anyone help me?

Date Text Value
01-12-2023 abc 1000
05-05-2023 xyz 1000
08-08-2023 efg 2000
05-04-2023 qrs 2500
02-10-2023 hij 3000
09-02-2023 klm 2500
01-02-2023 nop 1000

Want
01-12-2023 abc 1000
05-05-2023 xyz 1000
01-02-2023 nop 1000
05-04-2023 qrs 2500
09-02-2023 klm 2500

08-08-2023 efg 2000
02-10-2023 hij 3000

Regards

[binuacs]

@Kjaer One way of doing this

[Kjaer]

not quite like that. I just want two files. A file with data that exists multiple times and a file with data that exists only once.

[binuacs · Accepted solution]

@Kjaer updated workflow attached