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 val...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

thats randomly inserted data into excel.  other configs not in the original post have different numerical values.  I was expressing this condition.  Each configuration is denoted by a RecID and will have an Est. Renew $ value as well as a Renewal Term.  There are ony 5 options for Renewal Term 0-5 years.  It is also possible to have duplicate Est. Renew values but they are irrelevant to each other

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Would it be possible to provide some sample data in excel?

 

I want to recreate the issue first.

 

Thanks,

Tejaswi

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous ,

      Do you want somethign like this?

       

      Thanks,

      Tejaswi

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        where did the duplicates come from and the values don't match the original data (Config RecID 111 should be 1 for renewal term and the Est Renew $ should be blank.)