Monday, September 5, 2011

yogi_Flip Contents Of Two Columns With A Single Formula And Post Results In Another Sheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
rajvivek said:
How to Flip two columns contents with a SINGLE formula?
How is it possible to have a SINGLE formula to pull the content from column A to column D and from B to column C?
--------------------------------------------------------------------------
There is no direct way to do it ... however
A.  1) I can do it in another sheet, say Sheet2
      2) if column1 row1 of data is blank (or inconsequential)
      3) if there is a blank column available to the left of where data would be posted in Sheet2
or
B.  It can be done using the QUERY function, as shown in Sheet3

so here we go ...