9 Replies Latest reply: Jun 6, 2014 12:24 PM by Hoa Thang RSS

    Change Vertical data to Horizontal Dimension

    Greg Shelton

      HI, folks i have been struggleing with this and need some help.   I have some data in a QV Document that is in what i call a vertical format now like example below

       

      4-6-2012 12-56-02 PM.gif

      I want to convert it so that when i view in QV table object as this way

       

      4second one.gif

      I think i should be able to do it with Set analysis... I don't want to do it with the load script because i also need to be able to do a search on all owners with a particular model of car in a particular zipcode... etc.  but when i display the results of a serch in a report format i want to see all the customers cars on one line.

       

      nothing  i have tried so far seems to work.

       

      Thanks in advance!