Hi,
I have a requirement like this, I have input Columns,
CLNT, PLN, PQ, YTD
C1 P1 5.2 7.4
and I need output as
CLNT, PLN, RT, TR
C1 , P1 , PQ , 5.2
C1 , P1 , YTD, 7.4
I am getting TR column by using Horizontal pivot but Iam not getting RT output column which should contain input column names, is there a way to convert input column names as rows
Thanks,
SomaRaju.
Pivoting
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: