Hello,
I'm trying to build a pivot table with rows as weeks. Here is an example of what I'm looking for: The file I've uploaded has sorted it based on the week number. How can I sort and get the result below.
Week 1
Week 2
Week 3
etc.
Hello,
I'm trying to build a pivot table with rows as weeks. Here is an example of what I'm looking for: The file I've uploaded has sorted it based on the week number. How can I sort and get the result below.
Week 1
Week 2
Week 3
etc.
Personally, I would remove "Week " in your data so that you are just left with the numbers. Then the PivotTable will sort as expected.
or change in source table Week 1 to Week 01 etc then sort PT by A-Z
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks