Hello,
how can i Transpose this input Data like an Excel -
Input Data
| Name | ID | Type | year | Sum |
| honda | 345345 | Auto | 2022 | 35,635,635.00 |
| honda | 345345 | Auto | 2023 | 346,356.00 |
| honda | 345345 | Auto | 2024 | 678,678.00 |
| honda | 345345 | Auto | 2025 | 234,235.00 |
| Car | 467657 | Auto | 2022 | 325,636.00 |
| Car | 467657 | Auto | 2023 | 546,467.00 |
| Car | 467657 | Auto | 2024 | 2,444,556.00 |
| Car | 467657 | Auto | 2025 | 6,786,796.00 |
Output Data -
| Name | ID | Type | 2022 | 2023 | 2024 | 2025 |
| honda | 345345 | Auto | 35,635,635.00 | 346,356.00 | 678,678.00 | 234,235.00 |
| Car | 467657 | Auto | 325,636.00 | 546,467.00 | 2,444,556.00 | 6,786,796.00 |