You may try FILTERXML()
with index. Put below formula in D2
cell then drag down and right.
=IFERROR(INDEX(FILTERXML("<t><s>"&SUBSTITUTE($C2," ","</s><s>")&"</s></t>","//s[starts-with(., 'placement')]"),COLUMN(A$1)),"")
![enter image description here](https://i.stack.imgur.com/20OuN.png)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…