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    Feb 11, 2013
user meph2u said:(!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).


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