The Data I have - extracted (about 80+ columns for different people and about 150 rows for the codes):
The way I wanted to see the Data at the end (By each person only for the sites that there is data for. I do not want to see the zeros/blanks).
Your help will save me a day work to may be an hour or even less. Thanks.
Contribution Site Codes | Person-A | Person-B | Person-C | Person-D |
001-5500-000-55 | 50% | 50% | ||
003-6600-000-56 | 20% | 40% | 20% | 10% |
002-8800-000-57 | 20% | 30% | ||
001-0677-000-58 | 30% | 40% | 90% | |
Total From Each Person | 100% | 100% | 100% | 100% |
The way I wanted to see the Data at the end (By each person only for the sites that there is data for. I do not want to see the zeros/blanks).
Person-A | |
001-5500-000-55 | 50% |
003-6600-000-56 | 20% |
001-0677-000-58 | 30% |
100% | |
Person-B | |
003-6600-000-56 | 40% |
002-8800-000-57 | 20% |
001-0677-000-58 | 40% |
100% | |
Person-C | |
001-5500-000-55 | 50% |
003-6600-000-56 | 20% |
002-8800-000-57 | 30% |
100% | |
Person-D | |
003-6600-000-56 | 10% |
001-0677-000-58 | 90% |
100% |
Your help will save me a day work to may be an hour or even less. Thanks.