Row A has the following:
East
East
East
<-blank cell
East
East
<-blank cell
South
South
<-blank cell
South
<-blank cell
West
West
West
West
<-blank cell
West
<-blank cell
<-blank cell
West
West

I would like to copy "East" all the way down to the last East in the Row,
then inset a cell and type "East Total" and do the same for South and West.
The data changes from day to day. Can this be done? Here is the end result:
East
East
East
East<-was a blank cell
East
East
East<-was a blank cell
East Total
South
South
South<-was a blank cell
South
South<-was a blank cell
South
West
West
West
West
West<-was a blank cell
West
West<-was a blank cell
West<-was a blank cell
West
West
West Total