table to nested JSON

Hi Commynity, I need your help!! :slight_smile:

I’m trying to convert the following table into a nested json but I cant figure out how :frowning: The structure should be following:

Company1

------Date

---------Turnover

----------Ebit

----------EBITDA

----------Net debt

--------Date 2

----------Turnover

…

The table structure is as below. Can anyone help with this, please? :pray:

| Company   | Date      | Turnover | EBIT  | EBITDA | Net debt |
| Company 1 | 30.3.3020 | 1132     | 2344  | 546    | 4564     |
| Company 1 | 30.6.2020 | 3242     | 23423 | 45645  | 4566     |
| Company 1 | 30.3.3021 | 234234   | 2343  | 456    | 45665    |
| Company 1 | 30.6.2021 | 23423    | 23423 | 4566   | 45645    |
| Company 1 | 30.3.3022 | 2342     | 2323  | 564    | 54645    |
| Company 1 | 30.6.2022 | 234      | 234   | 56     | 45664    |
| Company 1 | 30.3.3023 | 2343     | 23    | 456    | 4565456  |
| Company 1 | 30.6.2023 | 23423    | 645   | 456    | 4565     |