4 Replies Latest reply on Dec 1, 2009 9:30 AM by conlin100

    Query exported to Excel lacks some data

    conlin100

      Title

      Query exported to Excel lacks some data

      Post

      I am using FM Pro Advanced 9.

       

      I have a database of student scores on tests, one for each year.  When I do a query and then export the results, I get rows that are blank, except for the test scores. Something like this:

       Joe   100 2009

               55  2008

               60  2007

      Mary   85  2009

               70  2008

               99  2007

       

       I want to sort & analyze the data.

       

      Well, I go in and manually copy the name down (Ctrl-D). Currently the file has about 60 students, so it  is not a big deal. But I would like to eliminate the manual work. Is there a way to get a file that would be like the following?

       

      Joe   100 2009

      Joe    55 2008

      Joe   60 2007

      ...

       

      Thank you in advance.

       

      Chuck Conlin