Hi, the only doubt I have is if we can change the column order after consolidating the table, or if we should start another table from scratch.
Edit pivot table --> Data Tab there is an option allow Drag and Drop..for re-arrange the column positions at( row/columns/measure level). if your not looking this option can you share your app. then it's easy to check and assist you. tks