Wednesday, December 13, 2017

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
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.


Thank you in advanced,

Amanda