AnsweredAssumed Answered

horizontal data

Question asked by amyaye on Jun 18, 2014
Latest reply on Jun 18, 2014 by philmodjunk

Title

horizontal data

Post

     how can i make my data appear like table two currently it looks like table 1. Iisit possible these fields can automatically create new multiple fields everytime a client visits or is this not possible. 

      

     table 1

      

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                    Name                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date
                    larry barry                     tv                     01/01/2014                     home                     599                     16/01/2014
                    larry barry                     radio                     07/08/2013                     store                     99                     14/08/2013
                    larry barry                     kettle                     01/05/2010                     store                     50                     05/05/2010

      

      

     table2

      

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
                                          visit1                     visit 2                      visit 3
                    Name                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date
                    larry barry                     tv                     01/01/2014                     home                     599                     16/01/2014                     radio                     07/08/2013                     store                     99                     14/08/2013                     kettle                     01/05/2010                     store                     50                     05/05/2010

Outcomes