Have you ever needed to merge multiple CSV files with millions of rows? If you search online, you'll find how to do so either with Power Query in Excel, or through Unix cat or Windows copy, or even with some custom Python script. However, all of these methods come with there own issues.
