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?
Pivoting columns to rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
Pivoting columns to rows
anudpETL