Monday, February 11, 2013

yogi_Combine Entities From Multiple Columns Into A Single Column


                                          Google Spreadsheet   Post  #1024
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 11, 2013
user meph2u said:(http://productforums.google.com/forum/?zx=fslt34ito72f#!category-topic/docs/spreadsheets/7-VAqLV1P9U)
Combine multiple columns of indefinite length into one and sort

I will be importing the data into columns A, B, and C.   The number of rows in each column can differ from import to import.

I want to combine all the names in the columns A, B and C into one list in Column G and support.

Is there a way to do that in one formula?  (I know, it doesn't take long to copy, paste three times and do a manual sort).

thanks.

https://docs.google.com/spreadsheet/ccc?key=0Atrb4wVf_dsSdGVPb0FNU0VmTmVxcE9vU0lsUWtPcFE#gid=0
--------------------------------------------------------------------------------------

following is a solution to the problem -- the merged data can be sorted either in ascending or descending order