D
Drew Pihlainen
I've got data in a format somewhat like this; essentially products sold on each day by each employee. The "Product" fields contain product numbers:
Name | Date | Product1 | Product2 | Product3 | Product4 |
John | 2 Aug | A506 | B207 | C405 | |
Mary | 2 Aug | B207 | D404 | | |
John | 5 Aug | A506 | C405 | | |
Mary | 6 Aug | E335 | | | |
I'd like the finished product to look something like this:
Name | Date | Product |
John | 2 Aug | A506 |
John | 2 Aug | B207 |
John | 2 Aug | C405 |
Mary | 2 Aug | B207 |
Mary | 2 Aug | D404 |
John | 5 Aug | A506 |
John | 5 Aug | C405 |
Mary | 6 Aug | E335 |
Any thoughts on how this might be done? Thanks!
Name | Date | Product1 | Product2 | Product3 | Product4 |
John | 2 Aug | A506 | B207 | C405 | |
Mary | 2 Aug | B207 | D404 | | |
John | 5 Aug | A506 | C405 | | |
Mary | 6 Aug | E335 | | | |
I'd like the finished product to look something like this:
Name | Date | Product |
John | 2 Aug | A506 |
John | 2 Aug | B207 |
John | 2 Aug | C405 |
Mary | 2 Aug | B207 |
Mary | 2 Aug | D404 |
John | 5 Aug | A506 |
John | 5 Aug | C405 |
Mary | 6 Aug | E335 |
Any thoughts on how this might be done? Thanks!