Dreamteam
New Member
- Joined
- Feb 22, 2018
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
Hi all,
I try to reserve any questions to this forum that are a little challenging - so apologies for the following as I really should know how to do this. In short, a taxi company has daily contracts and simply add which taxis took the job - at the end of the month the drivers get paid. The contracts are at the top, the dates on the side and whichever taxi does the job gets entered into the data in the spread sheet (taxis 3,5,6,7,8,14 or 15). All I want to do is flip this information so that the taxi references are at the top and the contracts are in the spread sheet. I have highlighted a possible scenario where one of the drivers complete more that 2 jobs in the day - I thought that this would be the only difficult part but for me I am struggling (looking at this I don't think it has come out highlighted). I have tried using Tables/Pivot Tables but to no avail.
Any help would be much appreciated.
Many thanks
Dt
CURRENT STATE
[TABLE="width: 1010"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DAY[/TD]
[TD]AM/PM[/TD]
[TD]COSAWES[/TD]
[TD]BASS ACC[/TD]
[TD]SWAN MONG[/TD]
[TD]PL PL SAINS[/TD]
[TD]BERKLEY COTT[/TD]
[TD]PL PL DRAC[/TD]
[TD]TREGEW[/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]AM[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]PM[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]AM[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]PM[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]AM[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]PM[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
WOULD I IMAGINE IT TO LOOK LIKE
[TABLE="width: 881"]
<colgroup><col><col span="2"><col span="2"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DAY[/TD]
[TD]AM/PM[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD]SWAN MONGL[/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]PM[/TD]
[TD]SWAN MONGL[/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]AM[/TD]
[TD]SWAN MONGL[/TD]
[TD]BERK COTT[/TD]
[TD][/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD]SWAN MONGL[/TD]
[TD]BASS ACC[/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]AM[/TD]
[TD]PL PL SAINS[/TD]
[TD]SWAN MONGL[/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]PM[/TD]
[TD]PL PL SAINS[/TD]
[TD]SWAN MONGL[/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD]BERK COTT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I try to reserve any questions to this forum that are a little challenging - so apologies for the following as I really should know how to do this. In short, a taxi company has daily contracts and simply add which taxis took the job - at the end of the month the drivers get paid. The contracts are at the top, the dates on the side and whichever taxi does the job gets entered into the data in the spread sheet (taxis 3,5,6,7,8,14 or 15). All I want to do is flip this information so that the taxi references are at the top and the contracts are in the spread sheet. I have highlighted a possible scenario where one of the drivers complete more that 2 jobs in the day - I thought that this would be the only difficult part but for me I am struggling (looking at this I don't think it has come out highlighted). I have tried using Tables/Pivot Tables but to no avail.
Any help would be much appreciated.
Many thanks
Dt
CURRENT STATE
[TABLE="width: 1010"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DAY[/TD]
[TD]AM/PM[/TD]
[TD]COSAWES[/TD]
[TD]BASS ACC[/TD]
[TD]SWAN MONG[/TD]
[TD]PL PL SAINS[/TD]
[TD]BERKLEY COTT[/TD]
[TD]PL PL DRAC[/TD]
[TD]TREGEW[/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]AM[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]PM[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]AM[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]PM[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]AM[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]PM[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
WOULD I IMAGINE IT TO LOOK LIKE
[TABLE="width: 881"]
<colgroup><col><col span="2"><col span="2"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DAY[/TD]
[TD]AM/PM[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD]SWAN MONGL[/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2019[/TD]
[TD]FRI[/TD]
[TD]PM[/TD]
[TD]SWAN MONGL[/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2019[/TD]
[TD]SAT[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2019[/TD]
[TD]SUN[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]AM[/TD]
[TD]SWAN MONGL[/TD]
[TD]BERK COTT[/TD]
[TD][/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2019[/TD]
[TD]MON[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD]SWAN MONGL[/TD]
[TD]BASS ACC[/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]AM[/TD]
[TD]PL PL SAINS[/TD]
[TD]SWAN MONGL[/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]PM[/TD]
[TD]PL PL SAINS[/TD]
[TD]SWAN MONGL[/TD]
[TD][/TD]
[TD]BASS ACC[/TD]
[TD]COSAWES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2019[/TD]
[TD]TUE[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD]BERK COTT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]