Solved

# Merge rows on Column B based on change of data on Column A

Posted on 2014-11-24

I need to merge Column B into one row based on the Column A value. Once the Column A value change, the new set of those rows will be merged. Below is an example:

Column A Column B

RMK_KEY RMK_TEXT

207 LEASE MAY BE EXTENDED ADDITIONAL 2 YEARS @ $100/PER

207 NET ACRE ($31.21)

208 OPTION TO EXTEND PRIMARY TERM FOR AN ADDITIONAL 2 YEARS

208 FROM THE EXPIRATION OF THE ORIGINAL PRIMARY TERM @ $600

208 PER NET MINERAL ACRES ($2,120)

The results should look like this:

207 LEASE MAY BE EXTENDED ADDITIONAL 2 YEARS @ $100/PER NET ACRE ($31.21)