Table with unique ID's but same values, how to filter out on values?
I have a table that looks like this:
ID VALUE1 VALUE2 VALUE3 VALUE4
1 TEST1 TEST2 TEST3 TEST4
2 TEST1 TEST2 TEST5 TEST6
This is a table populated by user data. I then want to organize the table so that the different TEST# shows the different ID's.
For instance, if I filter on TEST1 I would like to get ID 1 and 2. If I filter on TEST5 I would like to get ID2. How do I solve this? Anyone
The approach would be to normalize the data and then use a pivot table. This is a common request, so I wrote a generic program to do it. Sample file, instructions and macro are included in the attachment.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
The solution is to normalize the data and use a pivot table. Data normalization is a frequently-needed function, so I wrote a generic program to do it. A sample workbook, instructions and the macro are included in the attachment.
Thanks for the reply, I really appreciate you taking the time for this! This is basically what I'm looking for. I guess its not possible to do this in any other way than with a macro. Since this is not my strong side is it easy to customize the attached file to arrange a table that looks like this:
INPUT:
Skjermbilde.PNG
To this
OUTPUT:
Skjermbilde2.PNG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks