same ID based on group

BRRLL99

Hi

I have following dataset, if it starts with i| then new id has been assigned

data	id
i|	1
a	1
b	1
c	1
rrr 100- fgb	1
j	1
g	1
i|	2
j	2
k	2
l	2
t	2
101-gh	2

Expected output: based on ID, whenever it contains 100- , then entire id should be marked as same

i would like to do it using multi row formula instead of transpose, my original dataset has 10 million rows

data	id
i|	1	same
a	1	same
b	1	same
c	1	same
rrr 100- fgb	1	same
j	1	same
g	1	same
i|	2
j	2
k	2
l	2
t	2
101-gh	2

binu_acs

@BRRLL99 I think join tool would make it much more easier than multi-row tool becuase the key word 100- can any where in the row for a particular gooup that would make it much complex

Group_ID_14052024.yxmd