Creating a staggered report from a table

[paulmoss]

Hi

I hope that someone may be able to help me. I am trying to create a macro that will take certain information from a table and use it to create a table where the information is staggered. I have attached a spreadsheet that shows what I am trying to do.

Obviously, I could do it manually, but what I am aiming to achieve is to assign this macro to a button that will allow an end user to push a button and everything is done for them.

Any assistance on this will be greatly appreciated.

Regards

Paul Moss

[WideBoyDixon]

This commented code might do what you're after:

Please Login or Register  to view this content.

WBD

[maras_mak]

See if this macro works for you.

Please Login or Register  to view this content.

[paulmoss]

Thank you for your prompt responses, I will test these codes and advise if these solve my issue.

[paulmoss]

Once again thank you for your help with this. Both codes work, however, I realised that I messed up, the initial information I gave you was wrong, and for this, I apologise.
The output doesn't need to be staggered and I need to include an additional . I have attached an example of what I actually need.

Regards

Paul

[maras_mak]

Check this.

Please Login or Register  to view this content.

[WideBoyDixon]

Mine, also amended:

Please Login or Register  to view this content.

WBD

[paulmoss]

Thanks for the help. The updated code did the trick.