This is actually a follow question to one I already asked but there is a different end result. I have data that is broken into months on the x axis of a spreadsheet. The Y axis has a company name first in the A column and then three years, 2006-08, in the B column. This is kinda how it looks.
Company ABC 2006 1 2
2007 1 2
2008 1 2
Anyway, I need to sort a list of company's by alphabetical order, while keeping the yearly data in the same order.
Is there a special way of separating by groups and then sorting? I tried to highlight each group by using CTRL + highlighting with the mouse, then using the sort function, but it said I cannot sort by multiple fields.
Any thoughts? Thanks in advance.
PS. The diagram does not appear how it should when I submit it.