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     www.energyefficientbuild.com.   May-28-2014
post by j.kalintyler: (https://productforums.google.com/forum/#!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:

yDanielFrey
yKevinMukai
yHarryChawla

Pastes into:

yDanielFreyyKevinMukaiyHarryChawla

Fun.

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