I have a messy dataset with thousands of rows of sales data. Help me create a sophisticated Excel formula (or Power Query steps) to clean the data, extract unique customer IDs, and calculate the "Customer Lifetime Value" based on purchase frequency and average order value.