Unpivot should be possible without selecting anything. This is useful way to convert a file of column headers into rows for use with Rename Columns with Lookup
Workaround are:
Option 1: Add RowNo, then unpivot except for Row No
Option 2: Select all columns, apply, unselect all columns, apply