yogi_Rearrange Entries In 'Data Table' in 'RowNo - Col No' And 'Values' Table

Google Spreadsheet   Post  #2506

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-06-2018

question by: BPBC Tech
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/SiD3o67xGpk;context-place=mydiscussions
Calculating number of form submissions in Sheets for each individual

I am looking for help on how to query imported data, concatenate into a list in col1 and date sort by the values. Dataset example is the top table and the result i am looking for is the lower table. Thanks for any insight!