I a column Subjects under which I have 6 rows that list various subject list eg:
However, I want these rows to be displayed as Columns. However, I want it to be dynamic. Say if tomorrow a new row is added say G then that too should be dynmically be used as a column.
Please help me out..How can i do this? Using Pivot?