The Power Query add-in is an Excel add-in that allows you to connect, transform, and load data from a wide variety of sources. It can be used to transpose data from multiple sheets or workbooks in Excel.