Separating a Column that has Rows of Numbers and Rows of Strings

[Anonymous]

I have a data column that has a few rows with number values and a few rows with string values. Is it possible to seperate this column into two columns, one with numbers and one with strings. Here is a screenshot of my sample data.

I also want to keep the row in the same spot, so it is associated with the correct date, names, locations, and tasks.

[Anonymous]

Thank you!

[DOLEARY85 · Accepted solution]

Hi, 

if you create a couple of calculated columns in report view you can use:

Text =

SWITCH (

TRUE (),

ISERROR ( VALUE ( 'Table'[Column1] ) ), 'Table'[Column1],

blank()

)

Numeric =

SWITCH (

TRUE (),

ISERROR ( VALUE ( 'Table'[Column1] ) ), blank(),

'Table'[Column1]

)