Terry Stedl
New Member
- Joined
- Sep 29, 2003
- Messages
- 14
I posted this about a week ago but think it got deleted. Any ideas?
Is there a way to repeat items in a Pivot Table other than changing where the columns are placed or creating an additional data field that has a unique entry and putting it at the far left of the table? Using Excel 2003.
Current Pivot Table display where "Value" is the data.
Loc__City__ST__Order__Value
xyz__abc__aa__12345__$1000.00
______________23456__$2000.00
______________34567__$3000.00
Would like to output to display as below without making "Order" the first column in the table.
Loc__City__ST__Order__Value
xyz__abc__aa__12345__$1000.00
xyz__abc__aa__23456__$2000.00
xyz__abc__aa__34567__$3000.00
Is there a way to repeat items in a Pivot Table other than changing where the columns are placed or creating an additional data field that has a unique entry and putting it at the far left of the table? Using Excel 2003.
Current Pivot Table display where "Value" is the data.
Loc__City__ST__Order__Value
xyz__abc__aa__12345__$1000.00
______________23456__$2000.00
______________34567__$3000.00
Would like to output to display as below without making "Order" the first column in the table.
Loc__City__ST__Order__Value
xyz__abc__aa__12345__$1000.00
xyz__abc__aa__23456__$2000.00
xyz__abc__aa__34567__$3000.00
