I have a challenge (well its a challenge for me at the moment). I have a worksheet a manager created they want sorted, the issue is the data is of differing lengths and they only want to sort the first column, however keep the other columns data with the tag from the first. Let me explain:
we have 3 columns of data, lets say the data in column 1 is A2 – jones, A6 – smith, and A11 – miller. Column 2 is data A2-A4 associated with jones, A6 – A9 associated with smith, and A11-17 associated with miller, the same thing for column 3 multiple rows of data associated with the one row from column A. So the challenge is to sort column A alphabetically without losing the data from columns B and C associated with that name or lose the formatting of blank rows between each group. Ok I think that makes sense…of course it does to me as I am looking at it. Thanks for whatever info you can provide
