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...
if all your data is in a single structured table you can use "Match", "countif" and "Offset" to divide your table in to multiple tables according to the criteria you wish.
however if you have seperate tables you need to combine them in to one.
however if you have seperate tables you need to combine them in to one.