Forum Discussion
converting columns into rows
Hi all... I want to convert the Months ie., [columns] Apr, May, June etc... into rows with out unpivoting the table... [ I have almost 6.5 lakh records of multiple sheets combined as a single sh...
amitchandak wrote:In the matrix table, you can outcome like that. Any specific reason you want to store data into another table like that.
YES... NEED TO put month in a Slicer for selection and workout things...
Hi,
If you want a single month slicer, you will have no option but to use the "Unpivot Other columns" feature.