i am stuck about a formula to work out a workbook : i want to work the following. i am using this formula
=ARRAYFORMULA(Split(Transpose(Split(Query(Transpose(query(transpose(if(Input!B2:I<>"", ";"&Input!A2:A&"\"&Input!B2:I, )) ,,999^99)),,999^99), ";")), "\"))
but it does not give the desired results. Here is the desired output 'Automatically restructure all data from input tab as "Example Output" tab illustrates								
No rows for "blank" cells in the input tab								
Use formula(s) only in the first row - i.e. no need to drag cells down the entire sheet, and this tab auto updates when new entry made in Input tab"
get the sheets on this link 
https://docs.google.com/spreadsheets/d/1SY2k_yYb-YLWMUn-AYvxxYZLceOC5iMOjpBIDGhMUks/edit?usp=sharing and give ideas on how to improve the formula or insights into how you can do it differently