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
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.