how to split merged data into vertical saperate cells

		Microsoft Office Forums > Microsoft Excel > Excel
how to split merged data into vertical saperate cells

10-08-2014, 03:14 AM

cheekugreat cheekugreat is offline

Windows 7 64bit how to split merged data into vertical saperate cells

Office 2010 32bit

Novice

Join Date: Oct 2014

Posts: 2

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Accidentally merged cells?	Fraser	Excel	2	02-16-2014 10:15 PM
Excel Multiple Rows Merged into Word (Vertical Format)	ats1025	Mail Merge	3	11-19-2013 02:21 PM
Differences in borders at page break in merged cells	Sudlav	Word Tables	2	05-23-2013 11:50 PM
borders disappear from merged cells when pasting from excel	joba	Word	0	09-10-2012 11:35 AM
Set range for merged Word table cells?	tinfanide	Word VBA	1	02-06-2012 05:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:47 PM.