Notifications
Clear all
General Excel Questions & Answers
5
Posts
3
Users
0
Reactions
97
Views
Topic starter
I have columns of data that need to go into a table.
| Department | JOB CODE | TITLE | SALARY RANGE |
Min | Mid | Max |
I want to end up with:
a header row for department
columns that contain:
salary range
Min
Mid
Max
and title under the appropriate department and salary range. Very simple table looks like:
| department | ||||||
| salary range | ||||||
| min | mid | max | job title | |||
| sales dept, | advertising | |||||
| 5 | 2 | 6 | 10 | sales | ||
| 15 | 13000 | 25000 | 50000 | office mgr | ||
| 25 | 20000 | 44000 | 100000 | VP | ||
I started with a pivot table but cannot get the values to change to a label but am completely lost. I know there is a very simple answer that I've missed,
Posted : 01/03/2018 5:50 pm
Hi Jill,
Can you please upload a sample Excel file so we can see the before and after versions of what you'd like. We can help you better from there.
Thanks,
Mynda
Posted : 02/03/2018 4:14 am
hi Jill Niebieszczanski
may be its will help you
regarda/Saliha
Posted : 02/03/2018 5:42 am
Topic starter
I've been working this as a pivot but instead of the value, want the title.
Posted : 02/03/2018 9:33 am
Topic starter
not sure attachment saved the first time, sorry if a repeat.
Posted : 02/03/2018 9:35 am
