VBA - Convert data table into a long list (multiple columns)

[Jovannivk]

Hi everyone,


I'm running into a problem and can't convert it into VBA code.


In the attached appendix you will find a file with an analysis and output sheet. I would like to find something that adds data from a table per person to each other with the corresponding account code. In the output sheet I made an example of how I would like it to look.
So for each 'person' I have 3 values ​​that I must have among each other with the corresponding account code next to it. So this will be three lines. In this way I want x3 lines under each other for each person. Then the next item comes in, the same story here.


You could immediately use 6 lines for 1 person. However, in my work file I work with hundreds of persons and dozens of account codes. So I want as few 'zero' lines as possible in my output. Some account rules can be completely zero.


I hope that's a bit clear. Thanks for the help!


Greetings,
Jovanni