Balajibenz
Board Regular
- Joined
- Nov 18, 2020
- Messages
- 80
- Office Version
- 2013
- Platform
- Windows
Hi All, Can some one help me with below requirement.
I have below data as input in source sheet.
Below is the output I am excpecting in "Output" sheet.
What I am looking for is to have the data arranged in horizantally based on Dates.
I have only shown the sample of data here while I have much more lines in original source.
There is might two possible scenarios.
1. A person might have worked in multiple zones in same day or worked in single zone.
2. A person migt have worked in single zone throughout the week or single but different zones throughout the week.
If a person worked in different zone each day but only worked in single zone(eg: Gaitur, Cristina in the source data) then that has to be in single line.
If a person worked in multiple zones in same day then additional line needs to be added for that line and respective total needs to be populated(eg:Adamcova, Milena). but lets take Adamcova, Milena worked in TRK on 1/13/2021 but as this is the only zone she has worked on that day that should be populated in first line(Row:3) but not the next (Row:4). Thank you in advance.
I have below data as input in source sheet.
KW2_Gagu Personal & Polen.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Name | Date | Firm | Zone | Total | ||
2 | Adamcova, Milena | 1/11/2021 | Gagu Personal | OST | 1077 | ||
3 | Adamcova, Milena | 1/11/2021 | Gagu Personal | TRK | 100 | ||
4 | Adamcova, Milena | 1/13/2021 | Gagu Personal | TRK | 1135 | ||
5 | Adamcova, Milena | 1/12/2021 | Gagu Personal | OST | 1088 | ||
6 | Adamcova, Milena | 1/14/2021 | Gagu Personal | OST | 1348 | ||
7 | Adamcova, Milena | 1/15/2021 | Gagu Personal | OST | 1066 | ||
8 | Adamcova, Milena | 1/16/2021 | Gagu Personal | MSP | 1128 | ||
9 | Gaitur, Cristina | 1/11/2021 | Gagu Personal | OST | 331 | ||
10 | Gaitur, Cristina | 1/12/2021 | Gagu Personal | TRK | 71 | ||
11 | Gaitur, Cristina | 1/13/2021 | Gagu Personal | OST | 517 | ||
12 | Gaitur, Cristina | 1/14/2021 | Gagu Personal | OST | 57 | ||
13 | Gaitur, Cristina | 1/16/2021 | Gagu Personal | TRK | 148 | ||
14 | Zhydkova,Viktoriia | 1/11/2021 | Gagu Polen | OST | 580 | ||
15 | Zhydkova,Viktoriia | 1/15/2021 | Gagu Polen | OST | 707 | ||
Sheet4 |
Below is the output I am excpecting in "Output" sheet.
KW2_Gagu Personal & Polen.xlsx | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | 1/11/2021 | 1/12/2021 | 1/13/2021 | 1/14/2021 | 1/15/2021 | 1/16/2021 | |||||||||||
2 | Firm | Name | Zone | Total | Zone | Total | Zone | Total | Zone | Total | Zone | Total | Zone | Total | |||
3 | Gagu Personal | Adamcova, Milena | OST | 1077 | OST | 1088 | TRK | 1135 | OST | 1348 | OST | 1066 | MSP | 1128 | |||
4 | Gagu Personal | Adamcova, Milena | TRK | 100 | |||||||||||||
5 | Gagu Personal | Gaitur, Cristina | OST | 331 | TRK | 71 | OST | 517 | OST | 57 | TRK | 148 | |||||
6 | Gagu Polen | Zhydkova,Viktoriia | OST | 580 | OST | 707 | |||||||||||
Sheet3 |
What I am looking for is to have the data arranged in horizantally based on Dates.
I have only shown the sample of data here while I have much more lines in original source.
There is might two possible scenarios.
1. A person might have worked in multiple zones in same day or worked in single zone.
2. A person migt have worked in single zone throughout the week or single but different zones throughout the week.
If a person worked in different zone each day but only worked in single zone(eg: Gaitur, Cristina in the source data) then that has to be in single line.
If a person worked in multiple zones in same day then additional line needs to be added for that line and respective total needs to be populated(eg:Adamcova, Milena). but lets take Adamcova, Milena worked in TRK on 1/13/2021 but as this is the only zone she has worked on that day that should be populated in first line(Row:3) but not the next (Row:4). Thank you in advance.