Hello All ,
Looking for a solution to merge cells selective and keep data from both, then shift the remaining rows cell to the left.
This process is to align data columns were some rows have different cell counts. Any (B) cells with an x need to be merged with (A) preserving data. All '0A' data needs to line up.
The intent is to post process RS485 hex data . The messages will have text descriptors that sometimes use two consecutive row cells. This causes the actual raw hex data to offset column data for that row.
I need the open frame values '0A' and subsequent data to column align.
Merge it.JPGMerge it After.JPG
Bookmarks