Is there a way to insert a pivot table that creates a column and then puts everything in that columns row underneath it? For example, the attached spreadsheet has two columns; one for departments and one with employee names. I want it to list each department as a separate column header and then list each employee in the rows underneath the column with the department they are in. Is this possible? If not, is there another option besides a pivot table?
Example.PNG
Thank you!
Bookmarks