To whom it may concern,
It would be highly appreciated if you could help me to draw a pivot table in a sheet.
There is an Excel pivot table with 100 columns and 300 rows. It contains 100 students' test scores by date and some of them are listed unchronologically. By now, I learned to unpivot the table in order to draw a graph to see students' progress.
I have two questions.
Q1.
Could you please show me how to choose the items when unpivoting the table? There are like 200 items from 300 rows and wanted to select the right items and order them. Now I am using shift key to choose muptiple items one by one including unnecessary items. Is it easy to delete the wrong items from an unpivoted table?
Q2.
I would like to have a pivot table in a sheet view alongside the graph. I have a problem to create a pivot table. It would be highly appreciated if you could take a look at the attached with less valuables.
Thank you very much for your assistance in advance.
With gratitude,
Masako
