Sunday, March 24, 2019

yogi_transpose text data from 8 columns to vertical grouping in google sheet

Google Spreadsheet   Post  #2591

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-24-2019
question by: Brian Pugh
https://support.google.com/docs/thread/2937308?hl=en
Possible to transpose text data from 8 columns to vertical grouping in google sheet? 
I'm trying to help one of our teachers collect grad bios from our 8th grade students and send the data to the yearbook printer. The printer needs each student's submission to be grouped and listed in vertical order (see "vertical order" tab). Is there a formula that will transpose each student's 8 horizontally listed values into groups vertically? Thank you very much. example sheet
Details
Sheets, Microsoft Windows, Education
Posted by at
Labels: , , ,

1 comment:

  1. mrplit8March 24, 2019 at 2:04 PM

    Yogi, just amazing. I've just learned even more.

    I certainly "tip my hat" (allusion for old guys like me) to you for your expertise and you kindness.

    Brian

    ReplyDelete

Subscribe to: Post Comments (Atom)