Question: From the previous question, your data should be in an Excel Table. The first column contains data that looks like the data given below. Using
From the previous question, your data should be in an Excel "Table".
The first column contains data that looks like the data given below. Using text manipulation commands like Left, Right etc, extract the Month string, and place it in a column called Month. Assume you created a helper column called "dash".tableYearMonth,RegionGroupProductUnits RevenueAugust,southmilklow fat,$March,southice creamEdies$ January,leastmilkskim$March,Inorthice creamEdies$ January,southlice creamEdies$September,Iwestlfruitplums$March,leastmilklow fat,$June,
orthfruitlapples$July,Iwestfruitlcherries$May,southcerealSpecial K$June,Iwestlice creamEdies$ October,leastcerealRaisin Bran,$ June,southfruitgrapes$May,westmilkskim$June,IwestcerealRaisin Bran,$ March,southcerealRaisin Bran,$September,leastlice creamEdies$October,leastmilkchocolate$November,leastlice creamBreyers$May,southice creamBreyers$August,southmilklow fat,$ June,westlice creamEdies$April,Isouthlice creamEdies$February,Iwestlfruitplums$ November,leastcereallSpecial K$July,Inorthlice creamEdies$
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
