Colonnade Advisors, an M&A investment bank, faced a significant data challenge when a client provided customer data in an Excel file and CSV format. The data was disorganized, with customer information spread across multiple rows—sometimes as many as ten per customer. With hundreds of thousands of rows, the fragmented data made it nearly impossible to efficiently manipulate or analyze the dataset.