split alt+enter values of a cells into multiple cells

[bernandas]

dear all,


pl help me with macro for the following scenario. want to put the alt+enter values of same cells into multiple cells. have given base file and base file with required output. kindly do the needful.

base file 1138668789 1138668789 no out 1138668789 no out no out no out 906664998 10209438391 102083268873 101533616 102009914475 906674998 no likes 7774962 <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

required output

base file	required output
1138668789	1138668789
1138668789 23748729330 3847593203	1138668789	23748729330	3847593203
no out	no out
1138668789 34678237837	1138668789	34678237837
no out	no out
no out	no out
no out	no out
906664998 10209438391 102083268873 101533616	906664998	10209438391	102083268873	101533616
906674998	906674998
no likes	no likes
7774962	7774962

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>