Hi,
I have a data set with the Year column as 2003, 2014, 2003_2014.
I would like to:
1. Double the row of data for the Year containing 2003_2014
2. Then replace the content with =left(4) and =right(4) ==> 2003 and 2014 in the 2 rows respectively
how can this be done?
i am a complete newbie and have read all the other posts in the community but none seem to do this.
thank you in advance!
Solved! Go to Solution.
Hi @yzhang,
You may be able to use the Text To Columns tool and parse to rows for the "_" delimiter which will create 2 rows of data and duplicate the other fields, in this case the [Value]:
this is really the simplest answer i've seen in this forum! thank you! 🙂