This simple Query formula is your solution.
=query({resp3columns!A:D;resp3columns!A2:A,resp3columns!E2:G;resp3columns!A2:A,resp3columns!H2:J},"select * where NOT Col2='' order by Col1",1)
In the screenshot you can see variations with different numbers of data columns (3, 4, 6)
ADDED BONUS
You get your data ordered as well by Name or Model or any other column you may want.
Here is a Demo Spreadsheet you can play with and try out yourself.
This simple Query formula is your solution.
=query({resp3columns!A:D;resp3columns!A2:A,resp3columns!E2:G;resp3columns!A2:A,resp3columns!H2:J},"select * where NOT Col2='' order by Col1",1)
In the screenshot you can see variations with different numbers of data columns (3, 4, 6)
ADDED BONUS
You get your data ordered as well by Name or Model or any other column you want.
Here is a Demo Spreadsheet you can play with and try out yourself.
This simple Query formula is your solution.
=query({resp3columns!A:D;resp3columns!A2:A,resp3columns!E2:G;resp3columns!A2:A,resp3columns!H2:J},"select * where NOT Col2='' order by Col1",1)
In the screenshot you can see variations with different numbers of data columns (3, 4, 6)
ADDED BONUS
You get your data ordered as well by Name or Model or any other column you may want.
Here is a Demo Spreadsheet you can play with and try out yourself.
This simple Query formula is your solution.
=query({resp3columns!A:D;resp3columns!A2:A,resp3columns!E2:G;resp3columns!A2:A,resp3columns!H2:J},"select * where NOT Col2='' order by Col1",1)
In the screenshot you can see variations with different numbers of data columns (3, 4, 6)
ADDED BONUS
You get your data ordered as well by Name or Model or any other column you want.
Here is a Demo Spreadsheet you can play with and try out yourself.