-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Question about moving a row
- Thread starter silentir
- Start date
MrExcel
.
- Joined
- Feb 8, 2002
- Messages
- 3,417
- Office Version
- 365
- Platform
- Windows
Your pivot table has two rows with "Station 1" in the outer row field. You would like to move the second Station 1 to a new location in the pivot table, but when you move the second Station 1, the first Station 1 moves with it.
One solution is to combine Station and Form into a single field and use that as the outer row field. (You might even hide this column). The advantage is that Station 1/1004488 will be seen as completely different than Station 1/10044999.
Here is a video showing one solution:
One solution is to combine Station and Form into a single field and use that as the outer row field. (You might even hide this column). The advantage is that Station 1/1004488 will be seen as completely different than Station 1/10044999.
Here is a video showing one solution:
Upvote
0
Solution
