Hello
I am using excel 2007. I have a worksheet with Floor levels in column A and Activities in header row C1:M1 and I have inserted a Month in each cell co-relating to column and row for that floor/activity.
I am trying get this data in a Monthwise Format (see below) where multiple activities that scheduled in that Month and their respective floor are shown under that Month, so that it becomes easy for me to monitor the activities that are exepcted to be completed in that month.
I have entered above values manually to display the expected outcome. The list can be sorted by the Floor level or Activity.
I tried multiple options found on google, but am struggling to get my head around it.
Would really appreciate any help !
I am using excel 2007. I have a worksheet with Floor levels in column A and Activities in header row C1:M1 and I have inserted a Month in each cell co-relating to column and row for that floor/activity.
| Test - Index Match Monthly Activity.xlsx | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | Aug-23 | WING A | RCC | Brickwork | Internal Plaster | WATERPROOFING | ELECTRICAL | FLOORING / TILING / COUNTERS | WOODEN WORKS - DOORS | ALUMINIUM WORKS | ||
| 2 | A-BASEMENT2 | SLAB 1 | Done | |||||||||
| 3 | ||||||||||||
| 4 | A-BASEMENT 1 | SLAB 2 | Done | |||||||||
| 5 | ||||||||||||
| 6 | A-LOWER GROUND | SLAB 3 | Done | Done | Sep-23 | Oct-23 | ||||||
| 7 | 1 | 2 | ||||||||||
| 8 | A-UPPER GROUND | SLAB 4 | Done | Done | Sep-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Nov-23 | ||
| 9 | 1 | 0 | 1 | 2 | 3 | 3 | ||||||
| 10 | A-OFFICE STILT | SLAB 5 | Done | Done | Oct-23 | Aug-23 | Aug-23 | Nov-23 | Dec-23 | Jan-24 | ||
| 11 | 2 | 0 | 0 | 3 | 4 | 5 | ||||||
| 12 | A-OFFICE FIRST | SLAB 6 | Done | Done | Oct-23 | Sep-23 | Aug-23 | Dec-23 | Jan-24 | Jan-24 | ||
| 13 | 2 | 1 | 0 | 4 | 5 | 5 | ||||||
| 14 | A-2 | SLAB 7 | Done | Sep-23 | Nov-23 | Nov-23 | Sep-23 | Aug-24 | Feb-24 | Dec-24 | ||
| 15 | 1 | 3 | 3 | 1 | 12 | 6 | 16 | |||||
| 16 | A-3 | SLAB 8 | Done | Sep-23 | Nov-23 | Dec-23 | Sep-23 | Aug-24 | Nov-24 | Dec-24 | ||
| 17 | 1 | 3 | 4 | 1 | 12 | 15 | 16 | |||||
| 18 | A-4 | SLAB 9 | Sep-23 | Oct-23 | Dec-23 | Dec-23 | Oct-23 | Sep-24 | Nov-24 | Dec-24 | ||
| 19 | 1 | 2 | 4 | 4 | 2 | 13 | 15 | 16 | ||||
Sheet4 | ||||||||||||
I am trying get this data in a Monthwise Format (see below) where multiple activities that scheduled in that Month and their respective floor are shown under that Month, so that it becomes easy for me to monitor the activities that are exepcted to be completed in that month.
| Test - Index Match Monthly Activity.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | |||
| 2 | Sep-23 | Oct-23 | Nov-23 | Dec-23 | ||||||
| 3 | Floor | Activity | Floor | Activity | Floor | Activity | Floor | Activity | ||
| 4 | A-UPPER GROUND | Internal Plaster | A-5 | RCC | ||||||
| 5 | A-2 | Brickwork | A-6 | RCC | ||||||
| 6 | A-3 | Brickwork | ||||||||
| 7 | A-UPPER GROUND | Internal Plaster | ||||||||
| 8 | A-UPPER GROUND | ELECTRICAL | ||||||||
Result | ||||||||||
I have entered above values manually to display the expected outcome. The list can be sorted by the Floor level or Activity.
I tried multiple options found on google, but am struggling to get my head around it.
Would really appreciate any help !
