Hi,
I have a problem. I have around 300 Rows of data with uneven cells in different columns as below
<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
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