How to pull multiple Excel columns into one
As part of my continued effort to create a reference library for myself. I found this formula that I think I'll be using over and over again:
=TRANSPOSE(SPLIT(ARRAYFORMULA(CONCATENATE(TRANSPOSE(FILTER(A2:C,A2:A>0)&"-"))),"-"))
