Quote Originally Posted by SamT View Post
Large effort should be used to avoid merging cells in data structures.

Is there any way to achive your needs without merging cells?
my sheet is exactly as l explained in my post. let me give a more clear example

john physics
john maths
kate philosophy
kate biology
kate sociology

there are actually two individuals but five rows.l have to merge the unique values and the neigbour columns in the same range. unique values must be written once but the others must be protected.

once l do it, then l can use ms access to create a new excel sheet as unmerged cells. l have no other idea to achieve my goal but of course l am open for the new suggestions.

sincerely...