Google Sheets formula for bringing in checkbox info from sheet B to sheet A

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

What about specific columns instead of a range of columns for tab number 2?

I just updated the sheet above. Could we have different formulas that target multiple specific full columns instead of a range? Like before, the 1st tab has typed what i need it to show.

NOTE: These formulas would need to reference the correct Partner name to start as well. The RAW data will ultimately have a list of 1000 partners or so. As its filled out and a meeting is had with a partner, the partner name will be entered in tab "Official". Hopefully pulling a quick view of which items were accepted, denied or already using for that partner.

under the condition that the header cells of the "Official" tab must be the same as those used on a helper table on the "Raw" tab, you can do it like this:

on the "Raw" tab, in cell K3, make a copy of the persons name, and drag the formula down.

Then create a header row in cells K2:N2

Then in cell L3, use this formula:

Please Login or Register  to view this content.

and drag across and down
Screen Shot 2022-02-14 at 7.09.04 pm.png

then on the "Official" tab put this formula into cell B2:

Please Login or Register  to view this content.

and drag across, and down
Screen Shot 2022-02-14 at 6.59.48 pm.png