I want to Turn (Unique) Function into a Formula that works like this …
=N25:N29+O25:O29+P25:P29+Q25:Q29+R25:R29
enter image description here
enter image description here
This was an example of summing a few values in a formula that does that for 5 rows at the same time separately. (it Spills down to the other rows)

i can do the simple version of (unique) function that works for a single row like this …
=UNIQUE(N38:R38,TRUE,TRUE)
enter image description here
enter image description here

i can (copy/paste) the function for other rows but i dont want it like that , i want a formula that does it for multiple rows at the same time separately like the summing i did in the first example.(i want it to spill down to the other rows)

do anyone know how to do that ?

I tried it like this but it didnt work …
=UNIQUE(N32:N36&O32:O36&P32:P36&Q32:Q36&R32:R36,TRUE,TRUE)
enter image description here
enter image description here