VBA: create condition based loop, copy part of row and use header title : I have been trying to create a VBA which converts a raw data source into a usefull dashboard for reporting.

The challenges I encountered:
- Loop across columns, dismiss empty cells and continue loop afterwards
- Copy multiple sections of input table into destination table
- Use column heading of input table as column item in destination table

Thanks in advance for your help


 [Snippet of problem][1]


  [1]: https://i.stack.imgur.com/Tp43c.png