I just wanted to find out how to run a pivot table on a data that looks like this

Name Color 1 Color 2 Color3
Rob Green Yellow Black
Sidney Red Yellow

Normally, I need to flatten the data structure which means I have to make it into a structure that looks like this

Name Color
Rob Green
Rob Yellow
Rob Black
Sidney Red
Sidney Yellow

And then I can use a pivot table to run analysis

However, with the help of powerpivot - Can I run the same analysis without having to change the data structure?


Thank you very much