=IFERROR(INDEX(COLLECT(
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
Answers
-
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.
-
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.
Like it's explain in this forum : How to: Take data in a row and show it in a column in a dashboard. — Smartsheet Community
I don't know if it was solved
-
Are you able to provide a screenshot of your source data for reference?
-
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
-
Hi Paul,
Do you have a solution to solve my problem?
Thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!