I would like to get an advise regarding the following:
I have 3 columns, where there are some name or amounts in rows, or empty rows.
I want to copy into column ‘customer name’ only those items,which are names (otherwise keep it empty). Problem is that all data in the column has text format and if I am trying to convert the text to numbers- either through function asnumber or convert transformation, error shows up saying: “Can’t convert to number”.
Can you please help me?
THX in advance.
Can you provide an example of value that can’t be converted? It’s hard to say anything conclusive without seeing examples.