I have a list of data (see below) that has different position/depts/rates that i need to transpose into another excel sheet in a different format (Horizontal) instread of veritcally.
Data removed
Need the above data to be in the below format: I added this in manually show how i need the data...