Forum Discussion
Transpose Data
How do I transpose data in the excel sheet (on the left) to look like the output on the right? I want to transpose or pivot in such a way data I see the short description and see it's corr...
1:1 is not possible in my opinion. But can you please upload some sample data. I can try it but I wil not copy it from a screenshot.
| Month starts on | End Date | Group | User | Hours | FTE | Person Days | Category | Parent category | Number | Short description | Quarter | Remarks |
| 1/1/2023 | 1/31/2023 | OpsIT - Biologics Region | Francis, Maria | 44.00 | 0.25 | 5.50 | Project Allocated | Allocated | T1PRJ0299366 | Biologics: FMC - Discoverant Maintenance and Expansion | Q1 | OPS IT CC |
| 2/1/2023 | 2/28/2023 | OpsIT - Biologics Region | Francis, Maria | 40.00 | 0.25 | 5.00 | Project Allocated | Allocated | T1PRJ0299366 | Biologics: FMC - Discoverant Maintenance and Expansion | Q1 | OPS IT CC |
| 3/1/2023 | 3/31/2023 | OpsIT - Biologics Region | Francis, Maria | 46.00 | 0.25 | 5.75 | Project Allocated | Allocated | T1PRJ0299366 | Biologics: FMC - Discoverant Maintenance and Expansion | Q1 | OPS IT CC |
| 4/1/2023 | 4/30/2023 | OpsIT - Biologics Region | Francis, Maria | 40.00 | 0.25 | 5.00 | Project Allocated | Allocated | T1PRJ0299366 | Biologics: FMC - Discoverant Maintenance and Expansion | Q2 | OPS IT CC |
| 5/1/2023 | 5/31/2023 | OpsIT - Biologics Region | Francis, Maria | 46.00 | 0.25 | 5.75 | Project Allocated | Allocated | T1PRJ0299366 | Biologics: FMC - Discoverant Maintenance and Expansion | Q2 | OPS IT CC |