Move Content cell from one cell to another cell in different column ????

[ahmedit]

how to move content cells from one to another like the below
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]PISTON PIN BUSHING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 193"]
<tbody>[TR]
[TD="class: xl65, width: 193, align: left"]7101--355-070-0421[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]BRACKET[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 193"]
<tbody>[TR]
[TD="class: xl65, width: 193, align: left"]7101-0 481 007 012[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]SWITCH P.T.O[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 193"]
<tbody>[TR]
[TD="class: xl65, width: 193, align: left"]7101-0 481 039 222[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl65, width: 206"]VALVE REGULATOR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I want to move contents of cells from right column to left column to be like the below table
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl65, width: 240"]PISTON PIN BUSHING[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl65, width: 240"]7101--355-070-0421[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl65, width: 240"]BRACKET[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl65, width: 240"]7101-0 481 007 012[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl65, width: 240"]SWITCH P.T.O[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl65, width: 240"]VALVE REGULATOR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

how to do that ??????

 

[mole999]

are they offset like displayed

if so filter on the left for blank

in top cell = B what ever the line is, and drag down

when all across, unhide the other values, select all the a COPY and PASTE Values, then just delete the extra column