Greetings Toad Community.
I think I asked this question before, but is there any way I can add non-numeric characters in Pivot.
Results are something like this:
Col1
Col2
Col3
R1
C1
B
R1
C2
B
R2
C1
B
R3
C1
C
R3
C2
C
R4
C1
D
R4
C2
D
and the Pivot may be something like this:
C1
C2
R1
B
B
R2
C
R3
C
C
R4
D
D
This is very helpful with text analysis and aggregation.