Trying to replicate a formula

I wrote this formula for a spreadsheet years ago, its an order sheet for a restaurant, when the adjacent cell next to an item in the source sheet is marked with a number it appears on a different sheet, a neat list with no spaces in between. This list was to be emailed to the person buying the supplies. It worked great until someone changed the source and moved tables around. I don't use it anymore so I didn't think about it until I wanted to replicate the formula in different spreadsheet to do basically the same thing, but I cant remember exactly what I did. I've been trying to break it down and change the info but I just cant make it work in a new sheet. Can anyone explain this formula to me? Does this question even make sense?


These are the first 2 cells, the only difference in every formula is the very last number which is the destination for the source:

=IFERROR(INDEX(KITCHEN!B:B,SMALL(IF(KITCHEN!$A$4:$A$58<>0,ROW(KITCHEN!$A$4:$A$58)),ROWS($C$1:D1))),"")

=IFERROR(INDEX(KITCHEN!B:B,SMALL(IF(KITCHEN!$A$4:$A$58<>0,ROW(KITCHEN!$A$4:$A$58)),ROWS($C$1:D2))),"")

Can you attach the spreadsheet and someone may be able to figure out how to fix it.

Go Advanced -> Manage Attachments -> Upload

That's it, its an array formula. I don't know how I got that to work the way I wanted the first time, I was studying a tutorial at the time and somehow did it, now years later I don't understand it and cant replicate it. But thank you for telling me that, it has the curly brackets. I have to study array formulas again, ugh. No quick and easy copy for me this time. I will try and attach it if I can remember how to do that too.