Macro to insert rows and fill it with info from above

Hi everyone,
this is my first post here so please take me easy.

I have a file with hundreds of rows and I need to take the information inside and put it into a very different form (see the file attached). Basically I need to insert 6 rows before every existing row and all the info from the original row to put it into only 1 cell in the new row. For which a macro should be helpful put I don't have enough experience to write it.

If anyone has any idea it would be greatly appreciated.

Thanks in advance!

VBA coding a lot of times is all about finding the pattern. It's not clear if your pattern in the example will apply to your real sheet so I made a few assumptions. Try this (probably not bullet proof):

Please Login or Register  to view this content.

@stnkynts in my example I used 2 rows from my sheet and your macro is exactly what I need. Thanks a lot!