Resource 1 | Resource 2 | Resource 3 | Resource 4 | Resource 5 | Resource 6 | Resource 7 | Resource 8 | Resource 9 | Resource 10 | Resource 11 | |
Project A | 10 | 13 | 15 | ||||||||
Project B | 29 | 35 | 25 | ||||||||
Project C | 12 | 16 | 11 | 17 | 18 |
In a separate sheet, if I select the project, the resource names(Resource 1, Resource 2 and the like) should come in rows.The challenge is to have the resource names where ever the cells are non-empty. Resource names with empty values are not needed.
Eg: If I select Project A, Resource 1, Resource 7 and Resource 10 shall come as rows just below the project number.