Microsoft Office Forums - View Single Post - how to split merged data into vertical saperate cells

Thread: how to split merged data into vertical saperate cells

View Single Post

Old

10-08-2014, 03:14 AM

cheekugreat cheekugreat is offline

cheekugreat is offline

cheekugreat uses Windows 7 64bit

Windows 7 64bit cheekugreat uses Office 2010 32bit

cheekugreat uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Oct 2014

Posts: 2

cheekugreat is on a distinguished road

Default

how to split merged data into vertical saperate cells

Hi,
i have a data on following pattern

and want to split it into multiple rows like this.

please guide if these's any function or formula to do this task.
thanks.

Reply With Quote