Is it possible to stack values from 4 different columns from two different sheets into one column in third sheet using formula?

Asked May 18 '22 at 13:29

Active May 18 '22 at 13:29

Viewed 21 times

I need a formula that takes all the non-blank values from columns N and O in sheet1,
columns E and F in sheet2 and put them all in one column B in sheet3

asked May 18 '22 at 13:29

Pat

1

`=VSTACK(TOCOL(Sheet1!N:O,1),TOCOL(Sheet2!E:F,1))` – JvdV May 18 '22 at 13:34
it's giving me an #NAME1 error @JvdV – Pat May 18 '22 at 14:34

Is it possible to stack values from 4 different columns from two different sheets into one column in third sheet using formula?

0 Answers0