image-13 Power Query will allow you to manipulate and analyze data that is more than 1 million rows in Excel.