Displaying a selected row of data vertically
I have an excel sheet outputted from SIMS.net of some 150 rows of student data with filters applied.
The filters are used by tutors to select down to their tutor groups and then the individual data record (row) of interest.
Because of the width of the screen and a sheet with 80 plus columns it is difficult to assimilate the data once selected.
I would like to select a number of columns and display them vertically with their corresponding column headers. See second worksheet called Data Display.
I had thought that pivot tables would work but have not been successful, any ideas?