I have a table for translations with multiple texts and multiple languages.

The texts appear multiple times and sometimes the column for the language also appears multiple times.

I want to create a table that will have each text once with one translation (can be the first one that's available).

I'm trying to use an index, match formula but can't figure out how to search for the next option if the cell ends up to be blank.

Example: