Results 1 to 4 of 4

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

  1. #1

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

    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!

    Attached Files Attached Files

  2. #2

  3. #3
    Moderator VBAX Guru Aussiebear's Avatar
    Dec 2005
    Firstly, unmerge the cells C2:F2. Then select Cell C2 and use Excel's Text to Columns function to split the data based on commas.
    Next use the Replace function to change the "+" to ",".
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Mentor
    Sep 2019
    using VBA, so you need to test.
    i think this was requested before...
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts