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

A	B		D	E
1	x1	Expected Output	1	x1 x2
	x2
2	y1		2	y1 y2 y3
	y2
	y3
3	z1		3	z1
4	u1		4	u1 u2 u3 u4 u5
	u2
	u3
	u4
	u5

<tbody>
</tbody>

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