How to copy only rows with unique column value using bot

[Elvic]

I have a table "Recipes" with many repetitive items in the column. Using a bot I want to create a pivot- like table "Picklist".

"Recipes":

ID	Name	QTY
3344f6da	Salt	0
035055d0	Sugar	0.01
3d88b4e0	Salt	0.04
c6a6aa98	Salt	0.13
cb4a7341	Sugar	0.04
1c580461	Salt	0.03
7967772a	Salt	0.01
e04c2410	Salt	0.04
b8e9a123	Sugar	0.1

Result I want in "Picklist":

ID	Name	QTY
22e3e533	Salt	0.25
223fy54fe	Sugar	0.15

How to make the bot copying only the rows with unique Name... I am stuck with this problem(

[Elvic]

Among the other attempts, I tried to do it using a virtual column in "Recipes" but it seems like VC are not recalculated within the bot running process

[dbaum]

Consider making Picklist a parent table and Recipes a child table.

The "item-detail" data pattern - AppSheet Help