Thanks in advance for all the help. I'm not very well versed in Excel so I have no clue if this is an easy fix or not.
I created a sheet which ended of having merged cells (most of the sheet is pasted in) so when I attempted to sort I got the message
'To do this, all merged cells need to be the same size."
"The cell range that you attempted to sort or remove duplicates from includes merged cells. However not all cells in the range are merged to the same size.
To complete this operation, unmerge all the merged cells in the range, or make each group of merged cells the same size as the largest group."
I un-merged all cells all cell hoping to clear the error, but now when I sort all of the rows dis-align. See attached pictures for before and after attempted sort.
Bookmarks