Forum Discussion
Convert one table into several tables
Hi there, I have a table with columns: employee ID's, hours amounts, and wage types. I created a pivot table to break wage types into their own columns listing hours and amounts. But I need each...
Thank you so much Detlef. I did see this. But the tables are on separate worksheets, and I was hoping to have them on the same worksheet due to having specialists analysing data in webaps. That being said; I now realize that I may be able to make this work, as I can record a macro to have all worksheets combined into one after the specialists filtered each table for the highs and lows etc. Bu,t I wonder if I can now filter each table independent of the pivot table. This may post a challenge. I will post in.few days.