=TRANSPOSE(QUERY(sorting!A57:A,"select * where A contains '"&$A57&"'"))
This is what I'm currently using to make a word tree based on my A column. I want to find all instances of A57 in the A column and fill the rest of the row with those. I have 2 issues that I can't seem to squash:
SOLVED!
=TRANSPOSE(QUERY(sorting!A1:A,"select * where A matches "".\b"&$A1&"\b."""))
both problems 1 and 2 solved. thanks.