estillbham
New Member
I have employment data from a government employer with about 50 work sites. At each work site, there is a "Boss," sometimes an "assistant Boss," and several "Workers" (in the category I am analyzing). I have five years of data -- one year per sheet in each workbook.
In the Worker workbook, I have 200+ workers on each sheet. In the Boss workbook, I have 160 or so rows (remember, 1 or 2 rows per work site) per sheet. The work sites are designated by a number which can be used to match works ite data from one workbook to the other.
I want to analyze these data for the differences in the racial composition of the workers and the Boss/asst -- comparing the various work sites.
Should I create a Pivot Table of some sort?
Or should I figure out a way to break out the data from the existing tables so that I have one sheet per work site and all the data for the Bosses and Workers at each site on one sheet?
Your help will be appreciated.
In the Worker workbook, I have 200+ workers on each sheet. In the Boss workbook, I have 160 or so rows (remember, 1 or 2 rows per work site) per sheet. The work sites are designated by a number which can be used to match works ite data from one workbook to the other.
I want to analyze these data for the differences in the racial composition of the workers and the Boss/asst -- comparing the various work sites.
Should I create a Pivot Table of some sort?
Or should I figure out a way to break out the data from the existing tables so that I have one sheet per work site and all the data for the Bosses and Workers at each site on one sheet?
Your help will be appreciated.