I have a log file from equipment at my job that I am trying to organize to make it a more useful to me. I want to look through over 5000 rows in column A and when it finds a cell with the words "BHS ASSOCIATION FULLY AVAILABLE", it cuts it out and then paste it 3 rows up and one column over in B. Basically in column B directly across from the row in column A that has "REPT:CELL" in it.
Here is an example of the output from my log file that I pasted into column A.
[TABLE="width: 538"]
<tbody>[TR]
[TD] 58 REPT:CELL 945 CDM 2, CRC, HEH[/TD]
[/TR]
[TR]
[TD] SUPPRESSED MSGS: 0[/TD]
[/TR]
[TR]
[TD] ERROR TYPE: ONEBTS MODULAR CELL ERROR[/TD]
[/TR]
[TR]
[TD] SET: MLG-BHS ASSOCIATION FULLY AVAILABLE[/TD]
[/TR]
[TR]
[TD] MLG 1 DCS 2, SM 14, PSU 0, BHS 1[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] 01 05 02 00 00 01 01 00[/TD]
[/TR]
[TR]
[TD] 01 00 00 00 02 0E 01 00[/TD]
[/TR]
[TR]
[TD] 00 00 00 00 01 10 20 03[/TD]
[/TR]
[TR]
[TD] 00 00 00[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]10/11/18 02:58:41 #239639[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] 59 REPT:CELL 1025 CDM 1, CRC, HEH[/TD]
[/TR]
[TR]
[TD] SUPPRESSED MSGS: 0[/TD]
[/TR]
[TR]
[TD] ERROR TYPE: ONEBTS MODULAR CELL ERROR[/TD]
[/TR]
[TR]
[TD] SET: MLG-BHS ASSOCIATION FULLY AVAILABLE[/TD]
[/TR]
[TR]
[TD] MLG 1 DCS 2, SM 12, PSU 0, BHS 1[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] 01 05 02 00 00 01 01 00[/TD]
[/TR]
[TR]
[TD] 01 00 00 00 02 0C 01 00[/TD]
[/TR]
[TR]
[TD] 00 00 00 00 01 10 10 01[/TD]
[/TR]
[TR]
[TD] 00 00 00[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]10/11/18 02:59:02 #240536[/TD]
[/TR]
</tbody>[/TABLE]
Here is an example of the output from my log file that I pasted into column A.
[TABLE="width: 538"]
<tbody>[TR]
[TD] 58 REPT:CELL 945 CDM 2, CRC, HEH[/TD]
[/TR]
[TR]
[TD] SUPPRESSED MSGS: 0[/TD]
[/TR]
[TR]
[TD] ERROR TYPE: ONEBTS MODULAR CELL ERROR[/TD]
[/TR]
[TR]
[TD] SET: MLG-BHS ASSOCIATION FULLY AVAILABLE[/TD]
[/TR]
[TR]
[TD] MLG 1 DCS 2, SM 14, PSU 0, BHS 1[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] 01 05 02 00 00 01 01 00[/TD]
[/TR]
[TR]
[TD] 01 00 00 00 02 0E 01 00[/TD]
[/TR]
[TR]
[TD] 00 00 00 00 01 10 20 03[/TD]
[/TR]
[TR]
[TD] 00 00 00[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]10/11/18 02:58:41 #239639[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] 59 REPT:CELL 1025 CDM 1, CRC, HEH[/TD]
[/TR]
[TR]
[TD] SUPPRESSED MSGS: 0[/TD]
[/TR]
[TR]
[TD] ERROR TYPE: ONEBTS MODULAR CELL ERROR[/TD]
[/TR]
[TR]
[TD] SET: MLG-BHS ASSOCIATION FULLY AVAILABLE[/TD]
[/TR]
[TR]
[TD] MLG 1 DCS 2, SM 12, PSU 0, BHS 1[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] 01 05 02 00 00 01 01 00[/TD]
[/TR]
[TR]
[TD] 01 00 00 00 02 0C 01 00[/TD]
[/TR]
[TR]
[TD] 00 00 00 00 01 10 10 01[/TD]
[/TR]
[TR]
[TD] 00 00 00[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]10/11/18 02:59:02 #240536[/TD]
[/TR]
</tbody>[/TABLE]