0 Replies Latest reply: Sep 26, 2011 11:40 AM by jburgess RSS

    Goofy File

      I'm importing a rather akward .xlsx file.  The table structure looks

       

      Company      Project     Invoice Number     Amount

       

      Company x 

                          project b    

                                              ######                 $#####

                                              ######                 $#####

       

      Company y

                          project c

                                              ######                  $#####

       

       

       

      It carries on like this for a quite some time.

      These are weekly reports (from outside vendor) modifing them directly is not really an option.  The bosses don't care about real time either they prefer "Snap Shot" data analysis.