Transpose Vertical Data Horizontally

  • Re: Transposing Vertical Data Entries Into Horizontal Field Entries


    As well as visually showing us the problem, could you attach a worksheet with actual data?.:)


  • Re: Transpose Vertical Data Horizontally

    hi socktrot1984 (Ben)

    These are the types of things you would think that Microsoft would get right - the code is reasonable simpe

    make sure you place the cursor on the first entry



    But I always say luck is where preparation meets opportunity (Justin Langer 23/11/01)

  • Re: Transpose Vertical Data Horizontally


    Thanks a lot for the help.

    As requested I have attached a sample of the actual data.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]

    Thanks for this, it works in principle on the spreadsheet, however i have encountered a few more problems. In some cases each job number has a variable number of cost types, so over time the data entries that are now aligned with the vertical fields are out of sync with the job numbers. Is there anyway of rectifying the problem, perhaps by including a function in the formula that accounts for the number of cost types each job number has?

    I have included an updated sample of the spreadsheet to illustrate the point.

  • Re: Transpose Vertical Data Horizontally


    Thanks for your email, I needed to attach the file attached and could not see how that was done directly...

    Please look at the attachment, if you need further info, don't hesitate to email again.



  • Re: Transpose Vertical Data Horizontally

    Thats great, the code does exactly what I need!

    In addition I would like to be able move the rows with numerical values into a new tab without having to manually transfer them one by one. Is there anything I can do?

    The image below may help to visually represent what i mean. I would like only the rows in orange to be copied accross into a new tab.

    [Blocked Image:]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!