Forum Discussion
table transformation
Hi everyone, I have a table like in the example below I would like to transform it this way can someone help me?
Hi, provide sample data as table so we can copy/paste. Don't forget to describe what exactly you want to do with the data. Don't forget to provide also expected result based on sample data.
Thank,
there the data.
| Mese | Jan-24 | |||
| WBS | Revenue | Cost | Delta EAC Revenue | Delta EAC Cost |
| P.00434.1.12 | 4,000.00 € | 2,800.00 € | - € | - € |
| P.00615.1.01 | 19,000.00 € | 15,000.00 € | - € | - |
| P.00906.1.01 | 8,700.00 € | 8,000.00 € | - € | - € |
and here's what I expect
| data | commessa | Revenue | Cost | Delta EAC Revenue | Delta EAC Cost |
| 1/1/2024 | P.00434.1.12 | 4.000,00 | 2.800,00 | 0 | 0 |
| 1/1/2024 | P.00615.1.01 | 5000 | 2000 | 0 | 0 |
| 1/1/2024 | P.00906.1.01 | 8,700.00 € | 8,000.00 € | 0 | 0 |