With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.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.