1

I have a table that looks like this -

Key |    X      |    Y      |     Z
    |  Date     |   Date    |    Date
1a  | 01-Jan-16 | 15-Jan-16 |
2a  |           | 01-Feb-16 |   
3a  |           |           | 01-Mar-16

I need to do a pivot on this table, to get a resulting table that looks like this -

Key   |   Type   |   Date
1a    |     X    | 01-Jan-16
1a    |     Y    | 15-Jan-16
2a    |     Y    | 01-Feb-16
3a    |     Z    | 01-Mar-16

I've tried multiple versions of Pivot, but they don't get me all the data within these 3 columns. What might the best solution be?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
user3164272
  • 565
  • 1
  • 9
  • 20

1 Answers1

1

Delete the row with Date. Insert copies of your Key column immediately to the left of your Y and Z columns. Add two adjacent columns at a time using Multiple consolidation ranges, drill-down on the Grand Total intercept and filter the Value column to delete rows with blank cells. Label as appropriate.

Community
  • 1
  • 1
pnuts
  • 58,317
  • 11
  • 87
  • 139