Saturday, September 1, 2012

yogi_Combine List Of Entities In Column A From Page1 and Page2 Into Page3

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #724   Sep 01, 2012

user fugai7 said: (!category-topic/docs/P5zDL9Pf2Qs)
How do I link data from two different pages in a spreadsheet into one column on a separate page?
I need to combine two lists of names into one list in one column. The first list of names is in, let's say, Page 1 column A, and the second list Page 2 column B, and I would like them to be combined into a Page 3 column C (respectively with the list from 1A then below 2B). Any ideas? Help is greatly appreciated!
following is a solution to the problem