Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 value of the column.  Whats the easiest way to do this?

 

Thank you.

Need Help
Tutorial Requests

15 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    Pivot the config_customfield column. Use the other column in Values.

    Power Query->Transform tab.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I tried that first and I only have the option to unpivot which leaves me with a value column identical to the original

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I got this far but now I need to somehow condense the columns according to config_recid so that the null values aren't there.

    I used the Conditional Column function but I dont  think this method will allow me to remove the null values

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous ,

       

      Tring to understand your requirements.

      Do you want to replace Null with the values from the config_recid col?

       

      Thanks,

      Tejaswi

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        No,  referring to the original post.  I need to split the config_customfield column.  I need my table to look like this.