Hey team,
The TOCOL function in Excel 365 and Excel for Web can help you combine multiple columns into a single column. Check out how in this video.
Chapters:
0:00 Introduction
0:16 TOCOL Function Explained
1:30 Nested Functions in the TOCOL Function