best way to organize input table in excel

[Anonymous]

Hi guys,

What do you think is the best way to organize an excel input data table:

First option

Location                     KPI                                                     Date         Value

AA                  Energy consumption - Kwh         30/06/2019      100

AA                   Energy Consumption  - Kwh      31/07/2019      90

AA                   Energy Consumption - Kwh       31/08/2019     80

BB                    Energy consumption - Kwh         30/06/2019      50

BB                  Energy Consumption  - Kwh      31/07/2019      60

BB                 Energy Consumption - Kwh       31/08/2019     50

AA                  Water consumption - m3           30/06/2019      100

AA                   Water consumption - m3                31/07/2019      90

AA                   Water consumption - m3                 31/08/2019     80

BB                    Water consumption - m3                   30/06/2019      50

BB                  Water consumption - m3                31/07/2019      60

BB                 Water consumption - m3                 31/08/2019     50

Second option

Location                        Date                   Energy Consumption KWh       Water Consumption m3

AA                           30/06/2019                                           100                            100

AA                         31/07/2019                                               90                                  90

AA                        31/08/2019                                                 80                                   80

BB                           30/06/2019                                                50                                50

BB                        31/07/2019                                                  60                                 60

BB                      31/08/2019                                                  50                                  50

Thanks for your advice.

Regards

Rbn

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Both options are good choices. They can switch back and forth in edit queries by pivot column or unpivot columns.

And as far as I can see, I prefer the first option. Since it is easy for filter and classify KPI in the report.

Best Regards,

Lin

[Anonymous]

thanks @v-lili6-msft for you advice