Forum Discussion
How do I split a column according to another column?
I have this table here I am trying to split the "config_customfield" column into two columns using "Est. Renew $" and "Renewal Term" as column headers and "User_Defined_Field_Value" as the val...
Pivot the config_customfield column. Use the other column in Values.
Power Query->Transform tab.
I tried that first and I only have the option to unpivot which leaves me with a value column identical to the original