how to get the value present in list

[aswanim]

Hi,

I have column classification id and calssification as list. The list has only one value . Can you please let me know how to expand the list.

only one value is present in list.

May i know how to get the value that is present in the list.

Thanks.

[PhilipTreacy · Accepted solution]

Hi @aswanim 

Click on the Double Headed Arrow at the top of the column(s) and then click on Extract Values

Choose No Delimiter when prompted

You'll get errors where the null values were.  These can be replaced with whatever you like e.g. right click on the column header and choose Replace Errors

Just click OK on the next prompt

The result being this

regards

Phil