yogi_Flatten Row By Row multiple rows with non-overlapping values in columns into one row by subject

Google Spreadsheet   Post  #2326

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

question by: Vladimir

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

How to "flatten" rows? (multiple rows with non-overlapping values in columns into one row)

Hello,

I would like to ask for your help

1) I want to collect survey responses from Google, with different departments filling out different sections of the form (so in the data collection one row represents the answers of different departments, the answers do not overlap between departments). There will be multiple subjects with the same departments answering the questions.

2) I need to combine the rows (answers from all departments) for the given subject (kind of "flatten" the rows combining the answers from multiple departments into one row (one row for each subject).  All I can think of right now is to create multiple sheets (one for each subject), run a query like 
 " select * where B = 'ZLK' order by A "  and then add one row with JOIN()  (which is "kind of" doable, but requires additional sheets (number equal to number of subjects) and lot of manual input

Example datasheet
https://docs.google.com/spreadsheets/d/1PR2Vh4i2DeV7QiZi9znOxaY3vxabJF196wvWY_gROQs/edit?usp=sharing