Hi, I've been trying to get this done to analyze the data. However, I am unable to un-pivot this table. Could someone please guide me here?
Input table-
<tbody>
</tbody>
Desired Output-
<tbody>
</tbody>
Thanks in advance!
Input table-
A | A | A | A | A | B | B | B | B | B | |
WEEK | MON | TUE | WED | THURS | FRI | MON | TUE | WED | THURS | FRI |
1 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
2 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
<tbody>
</tbody>
Desired Output-
Business | Week | Day | Total |
A | 1 | MON | 100 |
A | 1 | TUE | 100 |
A | 1 | WED | 100 |
A | 1 | THURS | 100 |
A | 1 | FRI | 100 |
A | 2 | MON | 150 |
A | 2 | TUE | 150 |
A | 2 | WED | 150 |
A | 2 | THURS | 150 |
A | 2 | FRI | 150 |
B | 1 | MON | 100 |
B | 1 | TUE | 100 |
B | 1 | WED | 100 |
B | 1 | THURS | 100 |
B | 1 | FRI | 100 |
B | 2 | MON | 150 |
B | 2 | TUE | 150 |
B | 2 | WED | 150 |
B | 2 | THURS | 150 |
B | 2 | FRI | 150 |
<tbody>
</tbody>
Thanks in advance!