Hi
I have a document where every cell contains many values in it. These values can be split horizontally using Alt +D+E, but requires to be split vertically while retaining the vlaues of the adjacent cells as same.
I have attached the excel document for the clearer understanding. My document originally has 2000 such cells and finding it a tedious process to split it manaully while retaining the values of the adjacent cells as same.
Thanks for helping
Deep
Bookmarks