Hi there!
Im new to Excel/Sheets outside of a very basic level. So in not sure if this is doable.
I have 2 sheets. Sheet A needs to summarize data from Sheet B.
Sheet B has our partner name, and then which features are being used by checkbox (shown in True and False below). Sheet A needs to display as shown below. Matching the partner name and pulling in which features are checked with a comma in between each. What formula would i use in Sheet A to accomplish this?
Thank you in advance!
Sheet A:
--A--------B
1 Partner Features Used
2 Jane Doe Feature 1, Feature 3, Feature 6
3 Jack Doe Feature 2, Feature 3, Feature 4
Sheet B:
--A--------B---------C----------D----------E----------F---------G
1 Partner Feature 1 Feature 2 Feature 3 Feature 4 Feature 5 Feature 6
2 Jane Joe TRUE FALSE TRUE FALSE FALSE TRUE
3 Jack Doe FALSE TRUE TRUE TRUE FALSE TRUE
Bookmarks