Please find attached the file, I have tried to create a pivot for the data in two sheets, however I cannot move the headers into rows or columns
Ex: I want the "subject" and "Name" to be placed in rows and marks in column
I have created a pivot for the data in a single sheet, and need a new pivot for the data in multiple sheet in the same format
Power Query is available as a free add in download starting with Excel 2010. If you are using an earlier version-- otherwise google it and download. Talk to your IT department as this is a valid add-in to excel.