Forum Discussion

srkase's avatar
srkase
Icon for Helper IV rankHelper IV
6 years ago

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...
Need Help
srkase's avatar
srkase
Icon for Helper IV rankHelper IV
6 years ago
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...

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

If you want a single month slicer, you will have no option but to use the "Unpivot Other columns" feature.