I have the recurring need to concatenate values in an Excel Table but especially only unfiltered visible cells. (One common use case of mine is to get a list of Jira Issue Keys to easily link to multiple issues)
I explain here to solutions I know and share a VBA macro to do this in one click.
