Return a list of all matching headings for each row

[MichelleNeedsHelp]

Hi there. I'm not that great at Excel formulas and am hoping there is an easy way to do this. I have a relatively lengthy spreadsheet that is being used to track packages we provide to customers. The packages are grouped by tags, so when setting up a new customer, I would like to generate a list of the tags that are to be included for that customer rather than having to scroll through this massive spreadsheet and check each column individually. Eventually, I would like the ability to email the contents of the cell that contains this final list to the user that enters it, but for now, I just need a way to generate the entire list into a cell. Currently, this whole spreadsheet has been manually entered with no automation. I am looking to automate it as much as possible.

1. The tag columns span from column H to column W.
2. I need a way to identify all of the columns that are marked "True" for that client and return the column heading name (i.e. the name of the tag) to a list preferably in one cell located in the same row as the client. In the picture I am attaching, there is a column called "Include Tag" which is ultimately what I would love to have it look like (except not manually typed, lol).

Also, I feel like having these tag cells marked as "TRUE" might be problematic for formulas. Would love to change it to checkmarks. Is there a way to do that quickly?

I just can't seem to figure out how to do this.

Any help or guidance would be appreciated.

 

[JamesCanale]

TRUE is a great cell tag.

MrExcelPlayground18.xlsx
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10	Header 11	Header 12	Header 13	Header 14	Header 15	Header 16	Tag
2	TRUE	TRUE		TRUE		TRUE		TRUE	TRUE			TRUE			TRUE	TRUE	Header 1 Header 2 Header 4 Header 6 Header 8 Header 9 Header 12 Header 15 Header 16
3							TRUE						TRUE				Header 7 Header 13
4							TRUE						TRUE				Header 7 Header 13
5									TRUE		TRUE			TRUE	TRUE		Header 9 Header 11 Header 14 Header 15
6		TRUE				TRUE				TRUE			TRUE			TRUE	Header 2 Header 6 Header 10 Header 13 Header 16
Sheet19

Cell Formulas
Range	Formula
X2:X6	X2	=TEXTJOIN(CHAR(10),TRUE,FILTER($H$1:$W$1,H2:W2))

 

[MichelleNeedsHelp]

Thank you so, so much!! That is exactly what I needed!!!