Hi
I have a requirement where i would like to convert rows to columns(set of 10 for now) of one field XYZ based on a key column ABC.
Was trying to achieve it using reverse pivot transform but the input values are not constant. Is there any way to take input values dynamically and create only 10 new columns.
Please assist.
Thanks,
Abdulrasheed.