Question. Reference START POINT and DESIRED OUTCOME below. I used a Regex Tool to extract CAGE and the corresponding 5 digit code. If Reg2 is not null I want to extract the Company Name from Row +1 and enter it into Reg 2; add Company to Reg 1. START POINT... DownloadDataReg1Reg2yada yada yadanullnull 45152 CAGE45152 TACO BELL NullNullblah blah blahNullNullblah blah blahNullNull DESIRED OUTPUT.... DownloadDataReg1Reg2yada yada yadaNullNull 45152 CAGE45152 TACO BELL CompanyTACO BELLblah blah blahNullNull

Extract value in row + 1 and then replace null in preeceding column

Question.

Reference START POINT and DESIRED OUTCOME below.

I used a Regex Tool to extract CAGE and the corresponding 5 digit code.

If Reg2 is not null I want to extract the Company Name from Row +1 and enter it into Reg 2; add Company to Reg 1.

START POINT...

DownloadData	Reg1	Reg2
yada yada yada	null	null
<td class="KeyCellCtLnk" title="TACO BELL" onclick="fnShowLookup('CAGE', this.innerHTML);" ontouchstart="ehST(this,event);" ontouchend="ehET(this);">45152</td>	CAGE	45152
<td class="KeyCellLt DesktopOnly">TACO BELL</td>	Null	Null
blah blah blah	Null	Null
blah blah blah	Null	Null

DESIRED OUTPUT....

DownloadData	Reg1	Reg2
yada yada yada	Null	Null
<td class="KeyCellCtLnk" title="TACO BELL" onclick="fnShowLookup('CAGE', this.innerHTML);" ontouchstart="ehST(this,event);" ontouchend="ehET(this);">45152</td>	CAGE	45152
<td class="KeyCellLt DesktopOnly">TACO BELL</td>	Company	TACO BELL
blah blah blah	Null	Null