Skip to Content
0
Former Member
Jul 29, 2016 at 03:00 PM

Dynamic way of converting rows to columns

581 Views

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.