Dear Expert,
I need help in re-arranging this data. Pls see attached file.
I have data that would be coming into my report as shown in columns C - E of my attached spreadsheet. However, the data will need to be presented in another report in a collapsed format. Please see columns "H - K".
Please note that the table will be dynamic in nature. i.e. the table could increase or decrease based on the data available for that month.
Many thanks for your time!
Bookmarks