Trying to sort different values from different categories under other categories
Good morning,
First post.
I have an excel sheet with different companies on the X axis and different job positions on the Y axis. Additionally, various job positions have different levels based on experience. If the company is hiring that job position, I input their pay into the sheet.
Attachment for example, but this project is dozens of companies and 100+ job positions. Is there a way to display the position, then level, then have any non-zero companies underneath sorted by greatest to least? Attachment with desired output for reference.
|