Craigc3814
Board Regular
- Joined
- Mar 7, 2016
- Messages
- 217
I thought grouping would solve my issue but it does not, I have pivoted, and unpivoted this data so many times just to get to this point I am pretty let down.
In column 1 I have a header called EE Name which is just an employees name. Column 2 is called Attribute and it us just a 2 digit code for a certification that they have.
What I want to do is eliminate the duplicates in the EE Name column and make that the column header, then each unique attribute they have I want a row for that. So
Ken Puls A1
Ken Puls A2
Ken Puls A4
Miguel Escobar A1
Miguel Escobar A2
I want to turn into
Ken Puls Miguel Escobar
A1 A1
A2 A2
A3
A4
In column 1 I have a header called EE Name which is just an employees name. Column 2 is called Attribute and it us just a 2 digit code for a certification that they have.
What I want to do is eliminate the duplicates in the EE Name column and make that the column header, then each unique attribute they have I want a row for that. So
Ken Puls A1
Ken Puls A2
Ken Puls A4
Miguel Escobar A1
Miguel Escobar A2
I want to turn into
Ken Puls Miguel Escobar
A1 A1
A2 A2
A3
A4