Using Match/Index to bring multiple values

Hi,
I'm using the Match/Index formulas to bring values from another sheet. I need to bring many values in the same row (different columns) and the only way I found until now is to index as many times as I need in different cells, which is quite complicated if there's too many columns (I need 15 values from different columns in the same row).

Is there any way I can create some sort of array, list or something like it to bring all the values all together in one cell?

Thank you!
Regards!

Hi Javi, If I understand you

Hi Javi,

If I understand you correctly the easiest thing to do is to use the concatenate function on the other sheet to combine all the cells, then copy & paste special ? values onto the sheet you want it?

Regards
Mark