Unable to Merge Uneven Cells in Excel

[jpmayekar]

Hi,
I have a problem. I have around 300 Rows of data with uneven cells in different columns as below


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]x1[/TD]
[TD]Expected Output[/TD]
[TD]1[/TD]
[TD]x1 x2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]x2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]y1[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]y1 y2 y3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]y2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]y3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]z1[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]z1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]u1[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]u1 u2 u3 u4 u5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]u2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]u3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]u4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]u5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Columns A and B are input and Column C and D are Expected Output.

Please note Merging cells result in loss of Data. Welcome any suggestion on this and thanks before hand

 

[Fluff]

Excellent!!!!!!!!!!!!!

Glad to help & thanks for the feedback