Dear Awesome Excelians,
I'm at a stage in one of my teams' project where we need to segregate between the machines and their spare parts. Kindly find the attached file where I have shown the current situation and the required situation. At present we have the spare parts list on the left column and its associated machine numbers on the right columns.
We need to segregate by the machine number, i.e., vice versa, we need to have the machine numbers on the left column and have the spare parts for each associated machine on the right columns.
I'm at a stage in one of my teams' project where we need to segregate between the machines and their spare parts. Kindly find the attached file where I have shown the current situation and the required situation. At present we have the spare parts list on the left column and its associated machine numbers on the right columns.
We need to segregate by the machine number, i.e., vice versa, we need to have the machine numbers on the left column and have the spare parts for each associated machine on the right columns.