Hi All,
I have to populate a 3x4 table that is a list of our corporate projects. The projects belong to only one Division and Tier at a time. Projects progress from Tier 3 to 2 to 1. The data is sorted like this:
<tbody>
</tbody>
Does anyone know of a way to automatically populate a 3x3 table so the outcome looks like this?
<tbody>
</tbody>
A couple of other notes: I’ve simplified the issue quite a bit. There are typically 300 projects in the list and they are constantly in flux. I need to be able to produce this 3x3 table at a moment’s notice, hence the need for automation. Also I would like the projects to be listed in one cell. For example, Project A and Project H are listed in the same cell. I am pretty tied to this format.
Thanks for your help!
I have to populate a 3x4 table that is a list of our corporate projects. The projects belong to only one Division and Tier at a time. Projects progress from Tier 3 to 2 to 1. The data is sorted like this:
Proj_Name | Tier | Division |
Project A | 3 | Operations |
Project B | 3 | Revenue |
Project C | 1 | Operations |
Project D | 2 | Administrative |
Project E | 3 | Revenue |
Project F | 1 | Administrative |
Project G | 2 | Operations |
Project H | 3 | Operations |
<tbody>
</tbody>
Does anyone know of a way to automatically populate a 3x3 table so the outcome looks like this?
Tier 1 | Tier 2 | Tier 3 | |
Operations | Project C | Project G | Project A Project H |
Revenue | | | Project B Project E |
Administrative | Project F | Project D | |
<tbody>
</tbody>
A couple of other notes: I’ve simplified the issue quite a bit. There are typically 300 projects in the list and they are constantly in flux. I need to be able to produce this 3x3 table at a moment’s notice, hence the need for automation. Also I would like the projects to be listed in one cell. For example, Project A and Project H are listed in the same cell. I am pretty tied to this format.
Thanks for your help!