andersen_yunan
New Member
- Joined
- Feb 7, 2018
- Messages
- 36
Hi, I've been thinking to solve this problem for a while but to no avail
So I got bunch of raw data with delivery guys who would do shipment in a month like this
<tbody>
</tbody>
and I want to make a summary data that would be like this
<tbody>
</tbody>
Is there any formula that I could use to have result like this?
Any help would be appreciated. Thanks in advance!
So I got bunch of raw data with delivery guys who would do shipment in a month like this
MON-1 | TUES-1 | WED-1 | THURS-1 | FRI-1 | SAT-1 | MON-2 | TUES-2 | WED-2 | THURS-2 | |
Andrew | 12,00 | 12,00 | 12,00 | |||||||
Ashely | 12,00 | 11,00 | 12,00 | |||||||
Alan | 12,00 | 12,00 | 12,00 | 12,00 | ||||||
Billy | 12,00 | |||||||||
Charlie | 12,00 | 12,00 | 12,00 | |||||||
William | 12,00 | 12,00 | ||||||||
Wilbert | 12,00 |
<tbody>
</tbody>
and I want to make a summary data that would be like this
Visit Day | |
Andrew | TUES-1,THURS-1,MON-2 |
Ashely | MON-1,WED-1,THURS-2 |
Alan | TUES-1,FRI-1,TUES-2,WED-2 |
Billy | SAT-1 |
Charlie | TUES-1,TUES-2,WED-2 |
William | WED-1,THURS-1 |
Wilbert | MON-2 |
<tbody>
</tbody>
Is there any formula that I could use to have result like this?
Any help would be appreciated. Thanks in advance!