Pivoting columns to rows

anudeepdasari001 · Post by **anudeepdasari001** » Wed Mar 15, 2017 1:04 pm

Suppose i have a record say

Col1 col2
1 A,B
2 C
3 A,B,D

then i need the output as

Col1 Col2
1 A
1 B
2 C
3 A
3 B
3 D

COuld someone help me please?

rkashyap · Post by **rkashyap** » Wed Mar 15, 2017 2:01 pm

See this post. You can also look at thisone.

cdp · Post by **cdp** » Wed Mar 15, 2017 2:27 pm

Or this
Could easily be done using the Pivot Stage.

rkashyap · Post by **rkashyap** » Thu Mar 16, 2017 1:56 pm

Usually yes, but OP's example has variable no of columns to be pivoted!

chulett · Post by **chulett** » Thu Mar 16, 2017 3:25 pm

A 'variable' number isn't a problem as long as you know the maximum possible... and that maximum isn't a really big number.