Convert data in table to data in list

  • Hi


    Can somebody show me how to convert a table of data showing hours by date to a list so that I can pivot, etc. I just don't seem to be able to work this out.


    Example shows data in its native format in the first part of the spreadsheet and how I would like it to look in the second part.


    Many thanks in anticipation.


    TC

  • Re: Convert data in table to data in list


    There are many clues (comments) sprinkled about for you to deduce the methodology.
    If you open the hyperlinks, you can follow the macro as a pseudo instruction set.
    Another option is PowerPivot, if you are working off a big DataBase.

  • Re: Convert data in table to data in list


    Worked it out but didn't twig at first the double clicking on the count of values pivot and was wondering where on earth Table 2 came from!


    So easy when you know how - many thanks

Participate now!

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