Need help to overcome the "Text result of CONCATENATE is longer than the limit of 50000 characters." error message please.

Hello,

I am using this formula

=ARRAYFORMULA(
  SORT(
   UNIQUE(
    TRANSPOSE(
     TRIM(
      SPLIT(
       CONCATENATE(Data!D6:D&"|"),
       "|",TRUE,TRUE))))))

to show a list in a single column of all the tags I have in a games spreadsheet. As I've been expanding it, using the Show in same cell, individual control method in THIS POST. The expanding method works great, but it also has created another problem. The list of tags uses something similar to the Full column in the example spreadsheet they provided HERE.

The problem is that as I am adding tags, the formula stops working with the above error message. I did find a post a few years back, HERE, but am not sure how to implement it, and didn't understand much about it, or if there is a better solution, or a better formula to display them. How would I go about bypassing this limit please, or are there ideas of a better way to implement this perhaps? I prefer a formula I can put in the cell, but I can do other things, like possibly making a helper column or something else if needed, however, I do want there to be a list starting in this cell, and going down in a column with all of the tags that update automatically.

Thanks