I have a spreadsheet that compiled Employer of Choice data for several companies, with each company on a separate tab. Under category headers, we listed several components for each company that we found, i.e.: Childcare,Telecommuting, Free transportation, etc.
I'm pulling this data into Tableau (an infographic program) and would now like the lists to combine into one paragraph, separated by semicolons, that will show on the tooltip mouse-over. For example:
Childcare
Telecommuting
Free transportation
...would show as:
Childcare; Telecommuting; Free transportation
The problem is, some of these lists have 12 things, some have 3. I've tried to write formulas like IF(COUNTA(B17:B28)=6, B17&"; "&B18.... etc. that count down, but these have too many IF arguments. I don't want things that have only 3 items to end with "; ; ; "
Can someone please help?! I know there is a character limit for cells, so I've tried to write "and more" into the formula if it's greater than 6, but these are still too many if statements.
Attached is an example of one company tab.
Bookmarks