Unpivot data is fantastic to set up data for subsequent pivot table usage. However, I have a situation I can't determine. I have n columns marked Units <date> and n more columns marked Value <date>. Since the units on <date> go with value <date>, just unpivoting the columns leads to too many entries, which I have to delete, for instance units on date1 and value on date 2. Ultimately I need n rows per line not n^2. Does anyone have any ideas how to do that?