rcarroccio
New Member
- Joined
- Dec 9, 2014
- Messages
- 1
Hi,
I have a large spreadsheet with job applicant data. The first row is the job title (merged), and below are a list of applicants that applied for the position and other demographics. Under the complete list of job applicant data for job #1, I have another merged job title for job #2. I'm trying to find a way to efficiently put the merged section headers to an extra column in the table, so that I can easily pivot and filter on the data.
The section headers are in gray and bold, and I was thinking I could leverage conditional formatting or something along those lines to help, but my brain can't quite get there. Please help! Thanks!
I have a large spreadsheet with job applicant data. The first row is the job title (merged), and below are a list of applicants that applied for the position and other demographics. Under the complete list of job applicant data for job #1, I have another merged job title for job #2. I'm trying to find a way to efficiently put the merged section headers to an extra column in the table, so that I can easily pivot and filter on the data.
The section headers are in gray and bold, and I was thinking I could leverage conditional formatting or something along those lines to help, but my brain can't quite get there. Please help! Thanks!