Unpivot without selection

Support
1

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

2

Hi Joe,

In the latest version (3.5.0.3) it is possible to unpivot without checking anything. What version are you using?

PS. The canonical way of obtaining a list of column names is Keep 1 top row, then Unpivot without checking anything.

3

Ah, 3.5.0.2. Maybe that’s why. I will download 3.5.0.3

4

Edit: It actually does work (maybe it did in 3.5.0.2) as well, but I was expecting the “Apply” button to be available

Nope, still an ‘issue’ in 3.5.0.3. See screenshot

image.png1012×720 22.7 KB

This the first step to import a file with just the column headings

image.png1012×720 89.7 KB

5

I see your point. Yes, it’s a bug.

Looping in @vitaly.