I have a list of categories and items to include on the same row as those categories, but they are in a separate row and marked by numbers in another row. See uploaded .ods file for what I’m talking about.
Is there a way to check the number in the E column against the number in the A column and put all items for the corresponding D column into a cell together?
I was starting off trying something like =IF($E2=A$2, $D2, 0) and dragging it down and to the right.
Also considering using something along the lines of =INDIRECT(ADDRESS(E2+1; 2))