I have a table with "manufacturing quotes" and each quote has 1 or more parts in it (please see screenshot below). The data in parts1-3 (columns E-J) are filled, however, in reality, the quote includes only if that is specified in columns B-D.
I need to create a table with all the separate parts (which quotes they belong to doesn't matter) - each part is in its row - and append their info in respective columns.
I somewhat understand FILTER
and QUERY
functions but I can't find a solution to how to combine them with correct parameters in one formula to give the required query.
Input:
Output:
Editable sheet: https://docs.google.com/spreadsheets/d/1_2fRxrQqyZepQTkBVcDXrU2J_gEayY4X6KuszgE0uAg/edit?usp=sharing