converting columns into rows

Question

Hi all...&nbsp;&nbsp;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 sheet using query.&nbsp; when converting it takes a lot of time and during refresh also it takes lot of time]&nbsp;OR&nbsp;I want to insert month number into a calculated column ie., a new column as month number and values Apr means 4, May means 5 etc..&nbsp;Is it possible?&nbsp;My same dataYEARSHORTNAMEDEALERTYPEPRODUCTAPRMAYJUNJULAUGSEPOCTNOVDECJANFEBMARTOTCATEGORY20182019ABASTDPROD100000000000010PRODUCT20182019ACBSTDPROD200000000000020PRODUCT20182019ADASTDPROD300000000000030PRODUCT20182019ABASTDCAB0401000000000050CAB20182019ABASTDCAB0501000000000060CAB20182019ACASTDCAB000505050505050505050450CAB20182019ADASTDCAB000505050505050505050450CAB20192020ABASTDPROD100000000000010PRODUCT20192020ACBSTDPROD200000000000020PRODUCT20192020ADASTDPROD300000000000030PRODUCT20192020ABASTDCAB0401000000000050CAB20192020ABASTDCAB0501000000000060CAB20192020ACASTDCAB000505050505050505050450CAB20192020ADASTDCAB000505050505050505050450CAB&nbsp;Regards&nbsp;Ravikumar.S&nbsp;

amitchandak · Answer

In the matrix table, you can outcome like that. Any specific reason you want to store data into another table like that.

srkase · Answer

amitchandak&nbsp;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...&nbsp;

ashish_mathur · Answer

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

Forum Discussion

converting columns into rows

3 Replies

Related content

Open Mirroring CSV column types not converting

Convert measure to column

Convert calculated column into measure

converting rows into column in powerquery

Convert Rows to columns

YEAR	SHORTNAME	DEALER	TYPE	PRODUCT	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	JAN	FEB	MAR	TOT	CATEGORY
20182019	AB	A	STD	PROD	10	0	0	0	0	0	0	0	0	0	0	0	10	PRODUCT
20182019	AC	B	STD	PROD	20	0	0	0	0	0	0	0	0	0	0	0	20	PRODUCT
20182019	AD	A	STD	PROD	30	0	0	0	0	0	0	0	0	0	0	0	30	PRODUCT
20182019	AB	A	STD	CAB	0	40	10	0	0	0	0	0	0	0	0	0	50	CAB
20182019	AB	A	STD	CAB	0	50	10	0	0	0	0	0	0	0	0	0	60	CAB
20182019	AC	A	STD	CAB	0	0	0	50	50	50	50	50	50	50	50	50	450	CAB
20182019	AD	A	STD	CAB	0	0	0	50	50	50	50	50	50	50	50	50	450	CAB
20192020	AB	A	STD	PROD	10	0	0	0	0	0	0	0	0	0	0	0	10	PRODUCT
20192020	AC	B	STD	PROD	20	0	0	0	0	0	0	0	0	0	0	0	20	PRODUCT
20192020	AD	A	STD	PROD	30	0	0	0	0	0	0	0	0	0	0	0	30	PRODUCT
20192020	AB	A	STD	CAB	0	40	10	0	0	0	0	0	0	0	0	0	50	CAB
20192020	AB	A	STD	CAB	0	50	10	0	0	0	0	0	0	0	0	0	60	CAB
20192020	AC	A	STD	CAB	0	0	0	50	50	50	50	50	50	50	50	50	450	CAB
20192020	AD	A	STD	CAB	0	0	0	50	50	50	50	50	50	50	50	50	450	CAB