Excel formula, textjoin, delimiter

Copper Contributor
Alright so I want my spreadsheet to pull up all instances of a pokemon type in one search, and put each result on its own row.
So I look through the Kanto pokedex, I set up all the Pokemon with their types, and suceed to get it to show all water types using a textjoin formula, but I can not find a way to control the wrapping when I merge cells to cover the issue of 30 or 40 instances.
Delimiter says hard enter is an option, but I have not found a way to make it happen.
1 Reply
Alright so my answer was char(10)