Tableau/Pivot Help

profilejuskickz1
SampleData.xlsx

Sheet1

Title Agreement PP Days Week 1 Days Week 2 Days Week 1 Pivot Columns - Tableau Name Week 2 Pivot Columns - Tableau Name
User A Y 3 #Tuesday;#Wednesday;# #Thursday;#Friday;# Week 1 - Spilit 1 Week 2 - Spilit 1
User B Y 3 ;#Monday;#Tuesday;#Wednesday;# ;#Monday;#Tuesday;#Wednesday;# Week 1 - Spilit 2 Week 2- Spilit 2
User C Y 3 ;#Monday;#Tuesday;#Friday;# ;#Monday;#Tuesday;#Friday;# Week 1 - Spilit 3 Week 3 - Spilit 3
User D Y 3 #Thursday;#Friday;# ;#Monday;#Tuesday;#Friday;# Week 1 - Spilit 4 Week 4 - Spilit 4
User E Y 3 ;#Monday;#Tuesday;#Friday;# ;#Monday;#Tuesday;#Wednesday;# Week 1 - Spilit 5 Week 5 - Spilit 5