Find an exact text on a row

I think I know what you are asking but to avoid going down the wrong path, could you add a sheet (Hoja 3) tpo your file with the final result you want?
Makes it easier to understand.
A ver si te puedo ayudar.

I think this is what you wanted.
I used and extra column (Column G) in both Hoja 1 and Hoja 2
In these columns I placed the concatenated values of Column B, D, E and F from Hoja 1
Then in Hoja 2, using the Dic function I created the unique list for Column G and placed it in Column G in Hoja 2.
After that, I placed split the contents and placed the first part in Column A and the rest in Column C usign Column B like you did for the countifs.

Avísame si necesitás más explicación.

Espero que te ayude

Minor modification, replace this code for the macro

Please Login or Register  to view this content.

It's quite simple. If you execute the code line by line (pressing F8) you can see what it does.
If you're interested I'll explain the code. (en Castellano)