Sort Vertical as well as horizontally in a large data set

I am working on (what will be) a very large data set. I need to be able to sort the data horizontally depending on different criteria, eg. the sector they work in, the positions they have had in the past etc. I also need to be able to sort it vertically depending on their name, years of experience, current city they live in etc.

Since excel is amazing, I am convinced you can do this in a proficient way. I am just too stupid to do it.

I will attach a picture of what the data basic outlay looks like (so whoever see this can get an understanding of what the template looks like). I know it is in swedish but I need to be able to sort the data data between "B" to "U" and "6"-"11". What is important is that "6"-"11" will contain info from one person and I expect the same info from another 500 will be added below. Any ideas and recommendation are highly appreciated.

template.PNG

Thanks and let me know if I need tp provide more info,
Anton

Hi anton

Translating from Swedish is a little beyond me but am I correct in understanding that any 1 person's data will be spread over 7 rows (5-11). If so, then you will need an additional column where each of the 7 rows must have the person's reference.

I note that some of the rows contain merged cells. This will prevent vertical sorting.

Let me know if you want further information

Regards
Alastair

Thanks you and I really appreciate it. I am not sure I am following you on how that will work but I am pretty sure I will have to lay it out in a different way. The rows on the top is basically different fields in which the person currently work with. Let me know if you have any ideas of how to do this the easiest way. Anyway, I really appreciate your input.

Hi anton

Unfortunately I can no longer open the picture so I am working from (a very unrelable) memory.

I thought that the data was laid out as in the spreadsheet attached. Perhaps it would be best if you provided a sample of your spreadsheet?


Regards
Alastair

I really appreciate it! I realized I made it more difficult then it actually was. I decided to lay it out differently and just added an advanced filter to it and it will work out fine. Thanks tho!!

Hi anton

As we say - there's more than one way of skinning a cat!

Glad you found a solution

Regards
Alastair