yogi_Collate Multi-Column Data To A Single Column

Google Spreadsheet   Post  #2319

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-12-2017

question by: Amanda OConnor

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/xXilUzxoaYQ;context-place=forum/docs

Collating Multi-Column Data to a single ColumnFIRST TIME POST EVER - NEED HELP!

Greetings,

I am attempting to collate data from Columns A-H into a single column.

Ultimately, I would like for the Single Column List to look like:

A1

B1

C1

D1

E1

F1

G1

H1

A2

B2

C2

D2

...

If there is a blank value, I would like for it to skip and got to the next column.

https://docs.google.com/a/meraki.net/spreadsheets/d/1ttQnYlLR_fYn_8HorY6PEX3MTLMxQ4hhxQHCy-BpsZA/edit?usp=sharing

Thank you in advanced,

Amanda