I have data coming from an app that exports to Sheets in this format, & trying to get a formula to reformat it:
EmployeeName ShiftDate Store ShiftStart ShiftEnd
Person person 22/04/24 Our Store
Person person 23/04/24 Our Store
Person person 24/04/24 Our Store
Person person 25/04/24 Our Store
Person person 26/04/24 Our Store
Person person 27/04/24 Our Store 2024-04-27 16:00:00 2024-04-28 0:00:00
Person person 28/04/24 Our Store
Person PersonB 22/04/24 Our Store
Person PersonB 23/04/24 Our Store
Person PersonB 24/04/24 Our Store
Person PersonB 25/04/24 Our Store
Person PersonB 26/04/24 Our Store
Person PersonB 27/04/24 Our Store
Person PersonB 28/04/24 Our Store 2024-04-28 16:00:00 2024-04-29 0:00:00
Person PersonC 22/04/24 Our Store
Person PersonC 23/04/24 Our Store
Person PersonC 24/04/24 Our Store 2024-04-24 16:15:00 2024-04-25 0:00:00
Person PersonC 25/04/24 Our Store 2024-04-25 16:15:00 2024-04-26 0:00:00
Person PersonC 26/04/24 Our Store
Person PersonC 27/04/24 Our Store 2024-04-27 15:15:00 2024-04-28 0:00:00
Person PersonC 28/04/24 Our Store 2024-04-28 15:15:00 2024-04-29 0:00:00
…
Here’s how I’d like it to look (Note, the Shift Date column shows day/month/year, but the shift start & end shows the date formatted as year-month-date. Also, in the original the words “EmployeeName” are combined, & I’d like to separate them in the formatted version):
Employee Name Monday, April 22, 2024 Tuesday, April 23, 2024 Wednesday, April 24, 2024 Thursday, April 25, 2024 Friday, April 26, 2024 Saturday, April 27, 2024 Sunday, April 28, 2024
Person person 4:00 PM
12:00 AM
Person PersonB 4:00 PM
12:00 AM
Person PersonC 4:15 PM 4:15 PM 3:15 PM 3:15 PM
12:00 AM 12:00 AM 12:00 AM 12:00 AM
4:15 PM 6:45 AM
12:00 AM 3:15 PM
Tried a combination of query & transpose commands, but I’m not quite skilled enough to get it working to format it anywhere near what I need.