I have following columns in excel.
column A Column B Column C ColumnD
Type Number Dscription Author
enhancement 12345 test1 xyz
enhancement 67891 test2 Abc
Maintenance 14785 test3 DDX
project 54896 test4 UYT
project 25879 test5 MNU
Now in the pivot table, I have type and description to be in row labels. and I need 2 additional columns to just show Number and Author column in pivot as well without any operations. If I put number and author in the row labels they all get merged in one column (column A in the pivot table) which is not good and I do not want the report filter either.
so basically what we need is to have type and desctiption in column A in the pivot (row labels) and in column B in pivot table Number and Column C in pivot Author ( I do not need any specific operation like count or sum) I just want the data to show as it is.
How can this be done?