I have data which looks like below
Job1 Description1 Monday
Job2 Description2 Friday
Job3 Description3 Monday
Thursday
Job4 Description4 Monday
Job4 Description4 Tuesday
Wednesday
Thursday
Friday
Job5 Description5 Sunday
Job2 Description2 Friday
Job3 Description3 Monday
Thursday
Job4 Description4 Monday
Job4 Description4 Tuesday
Wednesday
Thursday
Friday
Job5 Description5 Sunday
I want write out an report in a single row like below
Job1 Description1 Monday
Job2 Description2 Friday
Job3 Description3 Monday Thursday
Job4 Description4 Monday Tuesday Wednesday Thursday Friday
Job5 Description5 Sunday
Job2 Description2 Friday
Job3 Description3 Monday Thursday
Job4 Description4 Monday Tuesday Wednesday Thursday Friday
Job5 Description5 Sunday
But I am not sure which option to use for this, could someone please help.