- Jun 6, 2020
- 11,559
- 4,422
I have been struggling to sort my data into one panel if the data is related. I have a timesheet with 7 days (see image), I have several months worth of employee data (total minutes worked) and I want to populate each day with the relevant data from that date range. example;
EmployeeID Name WeekNo Range
8000 John Doe 18 02-05-2022 - 08-05-2022
Mon Tue Wed Thu Fri Sat Sun
2.5 2.3 2.2 2.5 2.5 2.1 0
EmployeeID Name WeekNo Range
8000 John Doe 19 09-05-2022 - 15-05-2022
Mon Tue Wed Thu Fri Sat Sun
2.5 2.5 2.3 2.2 2.1 0 0
etc..
I have the data sorted by week numbers and employee ID, I am using the example from @Erel...
EmployeeID Name WeekNo Range
8000 John Doe 18 02-05-2022 - 08-05-2022
Mon Tue Wed Thu Fri Sat Sun
2.5 2.3 2.2 2.5 2.5 2.1 0
EmployeeID Name WeekNo Range
8000 John Doe 19 09-05-2022 - 15-05-2022
Mon Tue Wed Thu Fri Sat Sun
2.5 2.5 2.3 2.2 2.1 0 0
etc..
I have the data sorted by week numbers and employee ID, I am using the example from @Erel...
برای دیدن لینک ها باید ثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید