Generate 2 rows of data based on the content of 1 column

[yzhang]

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!

[Aaron_Harter · Accepted 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]:

[yzhang]

this is really the simplest answer i've seen in this forum! thank you! 🙂