Monday, August 20, 2012

yogi_Combine The Names In Two Columns And Show Them Appended In A Single Column

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #706   Aug 20, 2012

user nef426 said: (!category-topic/docs/spreadsheets/Z9ReQm1G1PE)
Show QUERY results in one column?
Hi there, 
I am trying to combine the names listed in two columns, into one column, dynamically using the query function, like this: 
=Query(A1:B5, "Select A, B") 
what do I need to add to make it display as a column, 10 cells tall, rather than two 5 cell tall columns? 
Thanks in advance

following is a solution to the problem