Wednesday, February 22, 2012

yogi_Merge Data In A Column From Different Sheets By Appending Consecutively

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #442

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.
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.