Timeline for Create a list of categories from a 2D array
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 21, 2017 at 7:27 | comment | added | Rubén - Volunteer Moderator -♦ |
There is a simpler way to get the concatenation of categories and subcategories: IF(LEN(A1:C3),{A1:A3,A1:A3&"-"&B1:C3}&",",). This should work with open references too.
|
|
| Dec 16, 2016 at 15:25 | vote | accept | Robert Hickman | ||
| Dec 15, 2016 at 1:51 | history | answered | user135384 | CC BY-SA 3.0 |