Merge and Unmerge Excel

elson_chua

New Member
Joined
Feb 15, 2019
Messages
1
Hi,

I had a file downloaded from somewhere, 3 rows were merged, when i perform unmerged, first and second row was file with data, how could this be done and what is the purpose of this ?
Appreciate your kind answer and thank you

BR//TE
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
before you unmerged, did the top left cell of the range contain that data ?. I can only think it was hidden and not really anything else
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,325
Office Version
  1. 365
Platform
  1. Windows
Cross posted https://www.excelforum.com/excel-new-users-basics/1264575-merge-and-unmerge-excel.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,367
Messages
5,547,508
Members
410,797
Latest member
mlfuson
Top