Unpivot Columns in Excel

[jomili]

Tried to give it a whirl but no go. I've attached my pivot so we can understand each other. For "Select the data range(including column header)" I take that to mean D1:I64. But when it says "Select the unpivot data range(only column header)." I have no idea what it's asking for. My best guess is to select only A1:I1, but that doesn't work.

[Admin]

But when it says "Select the unpivot data range(only column header)." I have no idea what it's asking for. My best guess is to select only A1:I1, but that doesn't work.

That will be your unpivot column range which is D1:I1

HTH