Quote Originally Posted by tahirawan11
Hi

I have two columns in my excel sheet namely 'Painting date' and 'Raw data'. Each cell in 'Painting date' column consist of 10 merged rows whereas 'Raw data' consists of single rows. The 'data' in 'Painting date' is unsorted'. I want to sort 'both' the columns as per 'Painting date' column. But the excel does not allow this and says ' The operation requires the merged cells to be identically sized'.

The only way around this is that i un-merge the 'Painting date' column into single row column and then do the sorting. But doing so manually takes lot of time and i have more than 1000 rows of data. Is there is any way i can un-merge the 'Painting date' column automatically/quickly. The format tool does not work.

'PLZ see the attached excel file for detail'

Thanks in advance

HI,

if you un-merge column A you will note there are values that are not displayed whilst the cells are merged.

No doubt you recall the 'merge' notifying you of multiple values.

This will make working with the data difficult, is this a true representation of your data?

---