The INDEX function is used to return a value or reference to a cell within a specified range or array. It can be used to reverse the order of rows or columns in your data when transposing it in Excel.