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:

y	Daniel	Frey
y	Kevin	Mukai
y	Harry	Chawla

Pastes into:

y

Daniel

Frey

y

Kevin

Mukai

y

Harry

Chawla

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