top of page
Search

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)&"-"))),"-"))


8 views0 comments

Recent Posts

See All
bottom of page