user SimonNY said:
How to consecutively add INDEX
How can I pull column data from multiple columns? The current formula I have merges the data together, but I want it to be consecutively added instead.
=INDEX(INDEX(Sheet1!A:A)&INDEX(Sheet2!A:A))
Thanks!
-------------------------------------------------
following is a solution to the problem where I have appended the data from column A of Sheet1, and then to that appended data from column A of Sheet2.
