pivot table assistance needed

smgomez · May 2, 2024

Below is a sample of a data set that looks like this. I want to summarize it as shown in the summary below, but can't seem to make that happen.

Employee	accounting exp.	administrative support exp.	aircraft maintenance exp.	aircraft mechanic exp.	benefits administration exp.	boilermaker exp.	building maintenance exp.
1
2
3							More than 10 years
4						Less than a year	1-5 years
5
6
7		6-10 years					1-5 years
8
9
10
11
12
13
14
15
16
17	1-5 years	1-5 years
18							1-5 years
19							1-5 years
20	More than 10 years	6-10 years			1-5 years
21		1-5 years					Less than a year
22					1-5 years		1-5 years
23
24							1-5 years
25
26
27	Less than a year	6-10 years			Less than a year		1-5 years

desired summary

	Less than a year	1-5 years	6-10 years	More than 10 years
accounting exp.	1	1	0	1
administrative support exp.	0	2	3	0
aircraft maintenance exp.	0	0	0	0
aircraft mechanic exp.	0	0	0	0
benefits administration exp.	1	2	0	0
boilermaker exp.	1	0	0	0
building maintenance exp.	1	7	0	0

smgomez · May 2, 2024

I figured it out. I used the Alt+D+P pivot wizard.