This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I tried to create two new columns ('Event' & 'Rotation Number') by extracting the data from column 'Rotation'. Currently, 'Rotation' column has a mixed of data both decimals and text, e.g. 0.4 & WSE. My desire out put are:
If Rotation is in decimal format, then add that to column 'Rotation Number', if it's in text format, then 'Rotation Number' should show as 0.
If the Rotation is in text format, then add that to column 'Event', if it's showing as '-' or 'na' then categorize those as Other as well.
I've attached the excel file here. I tried to use formulas here but it didn't seem to do all the trick. For example, in the extracting 'Event' information, I use the regex see screenshot below, it didn't write 'Prez Day' as it is and instead showed as 'Other'.
Similarly, for extracting the decimal numbers, it showed all 0.