=IFERROR(INDEX(COLLECT(

lea.s6 · 10/25/22

Moderator Note: Translated from French to English via Google Translate

Hi there,

I want to use the =IFERROR(INDEX(COLLECT() function to combine multiple data from different columns into a single column.

So I adjusted this function according to my need:

=IFERROR(INDEX(COLLECT({Dys D1}; {Dys D1}; <>""; {Dys D2}; {Dys D2}; <>""); 1); "")

However, when I put only one range with a criterion, the latter works very well but when adding the 2nd criterion, nothing is displayed.

Is there another method for multiple ranges? Knowing that I have about twenty columns to group.

Thanks in advance,

Cordially

Paul Newcome · 10/25/22

You are going to need to pull it together on a row by row basis on the source sheet. Then you can pull it over to the other sheet.

lea.s6 · 10/25/22

Thanks for your ansmer.

The problem is that the data of the diferrents columns came from a formular. So, the number of line in each columns change every day.

I would need a formula that groups the data and that goes to the next line if the one before is different from empty.

I don't know if it was solved

Paul Newcome · 10/25/22

Are you able to provide a screenshot of your source data for reference?

lea.s6 · 10/26/22

Hello,

Thanks for your answer.

I have the first sheet who the data come from a formular.

The second sheet : it's what I want to have :

And if another data came from the formular, I have to have the data after "TEST 21".

Thanks

lea.s6 · 11/30/22

Hi Paul,

Do you have a solution to solve my problem?

Thank you

Answers