doosam2000
New Member
Hi There
I have the following the data in row in excel
M
C
C
C
C
C
C
C
D
D
D
D
D
I
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
W
W
W
W
W
J
C
C
C
C
C
C
C
C
C
C
C
C
I
I
I
I
I
I
I
I
I
I
L
L
when i pivot it; the unique values display in the pivot table ROW wise; however the order goes off; i tried change the settings through data source in pivot table options; but no use.
Appreciate any one has solution.
Thanks
I have the following the data in row in excel
M
C
C
C
C
C
C
C
D
D
D
D
D
I
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
W
W
W
W
W
J
C
C
C
C
C
C
C
C
C
C
C
C
I
I
I
I
I
I
I
I
I
I
L
L
when i pivot it; the unique values display in the pivot table ROW wise; however the order goes off; i tried change the settings through data source in pivot table options; but no use.
Appreciate any one has solution.
Thanks