How to combine multiple columns into a vertical list in Excel
In this tutorial we will learn how to combine multiple columns into a vertical list in Excel by adding the contents of one cell to another.
For example, if you have data in columns A, B and C, the data can be combined in Excel to column D and formatted into a vertical list. This list can be delimited with any character of your choosing. We will use the concat function, which is short for concatenate, and the char function in Microsoft Excel to help accomplish this.
You can add this to your list of Microsoft 365 tips and tricks to make your job easier!
Check out these programs I use for YouTube
Bluehost discount: https://melcompton.com/recommends/blu...
Canva Pro Trial: https://melcompton.com/recommends/can...
Adobe: https://melcompton.com/recommends/adobe/
Filmora: https://melcompton.com/recommends/won...
Follow me on social media:
Facebook: / therealmelco. .
Twitter: @melissaecompton
Instagram: @melissaacompton
LinkedIn: / melissa-c. .
This description contains affiliate links and I may be paid a small commission should you purchase using these links.
#MelissaCompton #MicrosoftExcel #CombineColumns#VerticalList #Columns #Concatenate