Wednesday, May 28, 2014

yogi_Pull From Sheet1 Entries In Columns A To C And Put Them All In One Row

                                         Google Spreadsheet   Post  #1652
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-28-2014
post by j.kalintyler: (!mydiscussions/docs/joMoaBhmGVU)
Columns of data paste in all one row.
Going from new GD sheet to an old GD sheet, pasting (for instance) three columns and five rows comes out as one long row. Hoping that the data posts correctly, so for example:


Pastes into:



Any ideas?

Also, re-creating a couple hundred old GDs into new GDs is not an option. 

I had posted a formula in the forum ... following is an illustration for solution to a bit more generalized problem