Learn how to use the & (ampersand) and the TEXTJOIN() function to combine text from multiple cells into one cell and create dynamic text.
Download the tutorial file: https://github.com/alexsington/Data-S...
Intro: 0:00
Names: 0:20
Sentences: 1:43
Emails: 3:13
Dynamic text (interactive dashboard): 4:41