Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.

This is the demonstration file to accompany the article, How to use Microsoft Excel’s VSTACK() function to combine multiple data sets by Susan Harkins.

You can combine text from multiple cells into one cell in Excel using the Ampersand symbol (&) or by using the CONCATENATE function.