I would like to partially transpose a sheet that I have changing only some cells. For example, this:
|-----------------------------------------------------------------|
| Name | Database ID | Year | Month | Meter | value |
|-------+-------------+------+-------+-------------------+--------|
|Name 1 | 12998 | 2017 | 1 | Availability | 1.74 |
|Name 1 | 12998 | 2017 | 1 | Gross Generation | 2.241 |
|Name 1 | 12998 | 2017 | 1 | Irradiation | 3.683 |
|Name 1 | 12998 | 2017 | 1 | Performance Ratio | 4.26 |
|Name 2 | 11369 | 2017 | 1 | Availability | 5.95 |
|Name 2 | 11369 | 2017 | 1 | Gross Generation | 6.953 |
|Name 2 | 11369 | 2017 | 1 | Irradiation | 7.1556 |
|Name 2 | 11369 | 2017 | 1 | Performance Ratio | 8.543 |
|-----------------------------------------------------------------|
becomes this:
|--------------------------------------------------------------------------------------------------------|
| Name | Database ID | Year | Month | Availability | Gross Generation | Irradiation | Performance Ratio |
|-------+-------------+------+-------+--------------+------------------+-------------+-------------------|
|Name 1 | 12998 | 2017 | 1 | 1.74 | 2.241 | 3.683 | 4.26 |
|Name 2 | 11369 | 2017 | 1 | 5.95 | 6.953 | 7.1556 | 8.543 |
|--------------------------------------------------------------------------------------------------------|
The idea is that for each row with Name, Database ID, Year and Month then all values of Meter becomes a new column, with the value column as the cell data.
Name and Database ID should have the same values on each row, but Year, Month, Meter and Value can all vary.
Any help is really appreciated.
