Home

Convert one table into several tables

null null
Occasional Contributor
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 wage type to be it's own table with employee I'd, amount and hours.

I can splice the table, but I want it broken out into several tables so that the data can be filtered and analyzed and others can leave notes.

I would like to keep this on one sheet so that the data can be analyzed by multiple specialists in Excel web apps on SharePoint.

I have about 12 wage types but upwards of 30,000 employees. Not all wage types have hours. But all wage types have amounts.

I am hoping that the solution can be recorded with a macro as analysing is done about 9 times a week to varying populations.

Any assistance you are able to provide is greatly appreciated. I look forward to your response.

Thank you,

Snickers_&_Smores
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies