

New Member

September 2, 2022

Hello,
I wanted to make an Excel list that shows if it has assigned a task. The wanted result can be found in the picture below.
As you can see in the picture, the green version doesn't have any text that only contains rooms.
Do ask if this post was not clear enough. Thank you in advance!
BR, Excel noob


Trusted Members
Moderators
Power BI

January 31, 2022

If you are on a MS365 or in the web version, this formula could work (assume the blue table is called Table1):
=BYROW(FILTER(Table1,Table1[Tasks]<>""),LAMBDA(arr,TEXTJOIN(" ",,arr)))
A working example is attached. If this isn't working for you, please let us know your Excel version.
1 Guest(s)
