Is it possible to use filtering in a row and in a column

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I´m trying to make a solution were I may filter both in rows and in columns.

For example:
In Column D I´m using indata suchs as date of birth, education, name. Under
the namn I will have a two other indata from competence level within a
specific area. "Have" - "Wanted". It will be a great number of different
competences.

Example of excel:sheet 1
Under column A
Row1 "Name"
Row2 "Education"
Row3 "Age"
Row4 "Team"

Row6 "Competence 1"
Row7 "Competence 2"
Row8 "Competence 3"
Etc

Under Column B
Row1 Lisa
Row2 Dentist
Row3 45
Row4 1

Row6 2 (competence level)
Row7 3
Row8 3

What I´m trying to do is to place the filter in a column A and filter down
B,C,D
 
I would suggest that you organise your data differently, i.e. across
row 1 you would have the headings Name, Education, Age, Team,
Competence 1, Competence 2, Competence 3 etc, and then use one row for
each person. This will make it a lot easier to apply filters.

You can use Transpose to change your data from its current layout to
the layout I propose.

Hope this helps.

Pete
 
Back
Top