eunharanft
New Member
- Joined
- Feb 9, 2004
- Messages
- 49
In a pivot table how can I let every row to repeat in a column. I mean when I have a couple of items in the column, the first column shows the value only once on top. Is there a way to let it repeat every row? For example,
From
ABC 123
456
789
To
ABC 123
ABC 456
ABC 789
I need to sort it (I tried in Pivot sort, but it didn't work for the field that I have created) but this seems like the best way for now. Any help would be very much appreciated.
From
ABC 123
456
789
To
ABC 123
ABC 456
ABC 789
I need to sort it (I tried in Pivot sort, but it didn't work for the field that I have created) but this seems like the best way for now. Any help would be very much appreciated.