Forum Discussion
How do I split a column according to another column?
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
Hi Anonymous ,
Tring to understand your requirements.
Do you want to replace Null with the values from the config_recid col?
Thanks,
Tejaswi
No, referring to the original post. I need to split the config_customfield column. I need my table to look like this.
Hi Anonymous ,
And from where is your this data coming from? I dont see i in your screenshots.
Thanks,
Tejaswi
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