Incorporating sub-items into Excel reports

I just pulled our first monthly report as an Excel doc from I wanted to include sub-items, as the sub-items reflect as significant chunk of the work we’ve done.

The report is going to a management committee, and it only needs one row per project/task completed. I was hoping that the sub-items would simply be listed in rows subsequent to their parent projects, but they’re heavily formatted in a way that makes this report worthless for us to send. We’d have to go through and manually reformat the output so that sub-items are broken out of their indented rows so that all tasks are normalized.

Hopefully, reporting is something that will strengthen in the future.