Unpivot multiple group of Columns

[marmaghan]

Hi 

I am newbie here I am stuck on unpivoting multiple group of columns please help below is the scenario

I need two groups to unpivot like Column C to I & Column J to Column N  these column contains multiple particulars and value

the problem is I have to convert one group at a time so second group have multiple values. is there any way please help.

I have search lot of videos on youtube nothing was found helpful.

[v-yulgu-msft]

Hi @marmaghan,

Please follow this blog to provide more necessary information:

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[marmaghan]

Commission

Commission

Commission

Commission

Commission

Commission

Commission

Deduction

Deduction

Deduction

Deduction

Deduction

Month

Year

Dealer

Sub Region

Account No

NTN #

Registration

FILING

Comm

Biling

Devices

Bonus Recharge

Bonus Recharge Arrears

DO FR INCENTIVE

POSTPAID PROMO

WITHHOLDING TAX

TAX Adj (Upfront)

Sales Tax

Penalties

Handset Credit

Excuse me for the late reply pls check above data I need Commission and Deduction columns unpivot at same time in different columns like category commission Particulase & Value 1st group and 2nd group shuld be deduction particulars and value total 6 columns

I am unable to do this. 

[v-yulgu-msft]

Hi @marmaghan,

Based on above sample table, what is your desired result after "unpivot columns"?

Regards,

Yuliana Gu

[marmaghan]

Month

Year

Dealer

Sub Region

Account No

NTN #

Registration

FILING

Attribute

Attribute1

Value

Attribute3

Attribute4

Value

Commission

Biling

0

Deduction

WITHHOLDING TAX

0

Commission

Devices

0

Deduction

TAX Adj (Upfront)

0

Commission

Bonus Recharge

0

Deduction

Sales Tax

0

Commission

Bonus Recharge Arrears

0

Deduction

Penalties

0

Commission

DO FR INCENTIVE

0

Deduction

Handset Credit

0

Commission

POSTPAID PROMO

[Interkoubess]

Hi @marmaghan,

Could ou share sample data in order to make a try.

Thank you.

Ninter