I merged two worksheets together but I don't want the info merged into one row. I'd like one row to show the sales schedule and the row below to show the delivery schedule for each employee, based on the customer key. Could you help me find a way to ajust the info for all the data? Below are some examples of my data and how I would like it to look.
Thank you!
After Merge:
How I would like it to look:
Thank you!
After Merge:
Book8 (version 1).xlsb | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | CusKey | CusName | Service Day | Sales Person | CusKey | CusName | Service Day | Delivery Driver | ||
2 | 63510 | 1 | M | Jon | 63510 | 1 | T | Bill | ||
3 | 50430 | 2 | W | Jon | 50430 | 2 | TH | Bill | ||
4 | 63508 | 3 | M | Jon | 63508 | 3 | T | Bill | ||
5 | 63546 | 4 | W | Jon | 63546 | 4 | TH | Bill | ||
Sheet3 |
How I would like it to look:
Book8 (version 1).xlsb | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | CusKey | CusName | Service Day | Sales Person | Delivery Driver | ||
2 | 63510 | 1 | M | Jon | |||
3 | 63510 | 1 | T | Bill | |||
4 | 50430 | 2 | W | Jon | |||
5 | 50430 | 2 | TH | Bill | |||
6 | 63508 | 3 | M | Jon | |||
7 | 63508 | 3 | T | Bill | |||
8 | 63546 | 4 | W | Jon | |||
9 | 63546 | 4 | TH | Bill | |||
Sheet3 |