Forum Discussion
Transpose grouped columns
I'm trying to transpose rows into columns for a given group. My initial table looks like this with 13 columns Given Surname company Liveemail Contract Start Contract End Instructor Cost ...
Hi pranaysharmadel ,
The real question is: Why do you want to do this with your data? You're moving it away from the optimal structure for storage and reporting.
It sounds like an XY Problem to me. Can you explain what you're actually trying to achieve with your data and output please?
Pete
Its the business need. External systems are consuming the file.