muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
Hi,
I have the following data that gets produced from our timesheet website however it aligns our employees in a funny format. Each employee has an employee number however it sorts all the 1's 10's and 100's first and then so on. Is there a way to resort this data using the employee number as the guide so that it is in numerical order?
Thank you for your assistance!
I have the following data that gets produced from our timesheet website however it aligns our employees in a funny format. Each employee has an employee number however it sorts all the 1's 10's and 100's first and then so on. Is there a way to resort this data using the employee number as the guide so that it is in numerical order?
Thank you for your assistance!
SUBMITTED TIME REPORT -- 08312020 - Mon - 09062020 - Sun (5).csv | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | Date | Job | Employee | Time In | Time Out | Cost Code | Description | Hours | Earn Code | Amount | Approver | Equipment | Qty | Submitted By | Shift | Trade | Phase | Status | Row Modified On | ||
2 | 1 - A Doe | Subtotal Hours : 40 | |||||||||||||||||||
3 | 8/31/2020 | Test | 1 - A Doe | 7:00 AM | 3:00 PM | 200 - Floor - Tile | - | 8 | REG | $0.00 | Test | - | 0 | Test | - | - | 140 - Hall 1 | Approved | 09/09/2020 5:51 pm UTC | ||
4 | 9/1/2020 | Test | 1 - A Doe | 7:15 AM | 3:15 PM | 200 - Floor - Tile | - | 8 | REG | $0.00 | Test | - | 0 | Test | - | - | 134 - Sauna | Approved | 09/09/2020 5:51 pm UTC | ||
5 | 9/2/2020 | Test | 1 - A Doe | 7:00 AM | 3:00 PM | 200 - Floor - Tile | - | 8 | REG | $0.00 | Test | - | 0 | Test | - | - | 134 - Sauna | Approved | 09/09/2020 5:51 pm UTC | ||
6 | 9/3/2020 | Test | 1 - A Doe | 7:15 AM | 3:15 PM | 200 - Floor - Tile | - | 8 | REG | $0.00 | Test | - | 0 | Test | - | - | 121 - Mech. Room | Approved | 09/09/2020 5:51 pm UTC | ||
7 | 9/4/2020 | Test | 1 - A Doe | 7:15 AM | 3:15 PM | 200 - Floor - Tile | - | 8 | REG | $0.00 | Test | - | 0 | Test | - | - | 121 - Mech. Room | Approved | 09/09/2020 5:51 pm UTC | ||
8 | 107 - B Doe | Subtotal Hours : 32 | |||||||||||||||||||
9 | 8/31/2020 | Test | 107 - B Doe | 11:30 AM | 3:00 PM | 1200 - T&M - Demo Tile | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
10 | 8/31/2020 | Test | 107 - B Doe | 6:30 AM | 11:00 AM | 1200 - T&M - Demo Tile | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 127 - Party Hall Floor | Approved | 09/09/2020 5:51 pm UTC | ||
11 | 9/1/2020 | Test | 107 - B Doe | 11:30 AM | 3:00 PM | 1200 - T&M - Demo Tile | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
12 | 9/1/2020 | Test | 107 - B Doe | 6:30 AM | 11:00 AM | 1200 - T&M - Demo Tile | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
13 | 9/2/2020 | Test | 107 - B Doe | 11:30 AM | 3:00 PM | 1200 - T&M - Demo Tile | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Catering Kitchen R106 - Tile | Approved | 09/09/2020 5:51 pm UTC | ||
14 | 9/2/2020 | Test | 107 - B Doe | 6:30 AM | 11:00 AM | 1200 - T&M - Demo Tile | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Catering Kitchen R106 - Tile | Approved | 09/09/2020 5:51 pm UTC | ||
15 | 9/3/2020 | Test | 107 - B Doe | 11:30 AM | 3:00 PM | 1000 - T&M Tile Prep | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Catering Kitchen R106 - Tile | Approved | 09/09/2020 5:51 pm UTC | ||
16 | 9/3/2020 | Test | 107 - B Doe | 6:30 AM | 11:00 AM | 1200 - T&M - Demo Tile | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Catering Kitchen R106 - Tile | Approved | 09/09/2020 5:51 pm UTC | ||
17 | 112 - C Doe | Subtotal Hours : 49.5 | |||||||||||||||||||
18 | 8/31/2020 | Test | 112 - C Doe | 7:00 AM | 11:00 AM | 1 - General Costs | - | 4 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - NO PHASE | Approved | 09/03/2020 12:48 am UTC | ||
19 | 8/31/2020 | Test | 112 - C Doe | 11:00 AM | 4:00 PM | 300 - Vanity - Fabrication | - | 5 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
20 | 8/31/2020 | Test | 112 - C Doe | 6:00 AM | 6:30 AM | 210 - Backsplash - Fabrication | - | 0.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 154 - Mudroom | Approved | 09/09/2020 5:51 pm UTC | ||
21 | 8/31/2020 | Test | 112 - C Doe | 6:30 AM | 7:00 AM | 210 - Backsplash - Fabrication | - | 0.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
22 | 9/1/2020 | Test | 112 - C Doe | 6:00 AM | 1:00 PM | 300 - Vanity - Fabrication | - | 7 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
23 | 9/1/2020 | Test | 112 - C Doe | 1:00 PM | 4:00 PM | 310 - Countertop - Fabrication | - | 3 | REG | $0.00 | Test | - | 0 | Test | - | - | 131 - Laundry Room/Mud Room | Approved | 09/09/2020 5:51 pm UTC | ||
24 | 9/2/2020 | Test | 112 - C Doe | 11:30 AM | 4:00 PM | 206 - Shower - Fabrication | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
25 | 9/2/2020 | Test | 112 - C Doe | 6:00 AM | 11:30 AM | 300 - Vanity - Fabrication | - | 5.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
26 | 9/3/2020 | Test | 112 - C Doe | 6:00 AM | 7:00 AM | 206 - Shower - Fabrication | - | 1 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
27 | 9/3/2020 | Test | 112 - C Doe | 7:00 AM | 8:00 AM | 300 - Vanity - Fabrication | - | 1 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
28 | 9/3/2020 | Test | 112 - C Doe | 8:00 AM | 9:00 AM | 210 - Backsplash - Fabrication | - | 1 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
29 | 9/3/2020 | Test | 112 - C Doe | 9:00 AM | 4:00 PM | 700 - Fireplace - Fabrication | - | 7 | REG | $0.00 | Test | - | 0 | Test | - | - | 107 - Master Bedroom | Approved | 09/09/2020 5:51 pm UTC | ||
30 | 9/4/2020 | Test | 112 - C Doe | 1:00 PM | 4:00 PM | 20 - Shop and Equipment Maintenance | - | 3 | REG | $0.00 | Test | - | 0 | Test | - | - | 125 - LMT Shop | Approved | 09/09/2020 5:51 pm UTC | ||
31 | 9/4/2020 | Test | 112 - C Doe | 6:00 AM | 8:00 AM | 700 - Fireplace - Fabrication | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 107 - Master Bedroom | Approved | 09/09/2020 5:51 pm UTC | ||
32 | 9/4/2020 | Test | 112 - C Doe | 8:00 AM | 12:30 PM | 207 - Tub Wall- Fabrication | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
33 | 114 - E Doe | Subtotal Hours : 39 | |||||||||||||||||||
34 | 8/31/2020 | Test | 114 - E Doe | 11:30 AM | 3:00 PM | 1201 - T&M - Install Tile & Coping | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
35 | 8/31/2020 | Test | 114 - E Doe | 6:30 AM | 11:00 AM | 1201 - T&M - Install Tile & Coping | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
36 | 9/1/2020 | Test | 114 - E Doe | 11:30 AM | 3:00 PM | 1201 - T&M - Install Tile & Coping | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
37 | 9/1/2020 | Test | 114 - E Doe | 6:30 AM | 11:00 AM | 1201 - T&M - Install Tile & Coping | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
38 | 9/2/2020 | Test | 114 - E Doe | 11:30 AM | 3:00 PM | 1201 - T&M - Install Tile & Coping | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/03/2020 10:08 am UTC | ||
39 | 9/2/2020 | Test | 114 - E Doe | 6:30 AM | 11:00 AM | 1201 - T&M - Install Tile & Coping | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/03/2020 10:08 am UTC | ||
40 | 9/3/2020 | Test | 114 - E Doe | 11:30 AM | 3:00 PM | 1201 - T&M - Install Tile & Coping | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
41 | 9/3/2020 | Test | 114 - E Doe | 6:30 AM | 11:00 AM | 1201 - T&M - Install Tile & Coping | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
42 | 9/4/2020 | Test | 114 - E Doe | 6:30 AM | 1:30 PM | 1201 - T&M - Install Tile & Coping | - | 7 | REG | $0.00 | Test | - | 0 | Test | - | - | 1 - Existing Pool | Approved | 09/09/2020 5:51 pm UTC | ||
43 | 14 - F Doe | Subtotal Hours : 39 | |||||||||||||||||||
44 | 8/31/2020 | Test | 14 - F Doe | 2:00 PM | 3:00 PM | 20 - Shop and Equipment Maintenance | - | 1 | REG | $0.00 | Test | - | 0 | Test | - | - | 125 - Lander Maintenance | Approved | 09/09/2020 5:51 pm UTC | ||
45 | 8/31/2020 | Test | 14 - F Doe | 7:00 AM | 9:00 AM | 20 - Shop and Equipment Maintenance | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 125 - Lander Maintenance | Approved | 09/09/2020 5:51 pm UTC | ||
46 | 8/31/2020 | Test | 14 - F Doe | 9:00 AM | 1:00 PM | 601 - Tub Surround - Slab | - | 4 | REG | $0.00 | Test | - | 0 | Test | - | - | 103 - Bathroom 2 | Approved | 09/09/2020 5:51 pm UTC | ||
47 | 8/31/2020 | Test | 14 - F Doe | 1:00 PM | 2:00 PM | 10 - Pickups and Delivery | - | 1 | REG | $0.00 | Test | - | 0 | Test | - | - | 155 - Service | Approved | 09/09/2020 5:51 pm UTC | ||
48 | 9/1/2020 | Test | 14 - F Doe | 10:30 AM | 12:30 PM | 311 - Countertop - Slab | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Kitchen 1 | Approved | 09/09/2020 5:51 pm UTC | ||
49 | 9/1/2020 | Test | 14 - F Doe | 12:30 PM | 2:30 PM | 301 - Vanity - Slab | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 103 - Bathroom 2 | Approved | 09/09/2020 5:51 pm UTC | ||
50 | 9/1/2020 | Test | 14 - F Doe | 6:30 AM | 10:30 AM | 601 - Tub Surround - Slab | - | 4 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Bathroom 1 | Approved | 09/09/2020 5:51 pm UTC | ||
51 | 9/2/2020 | Test | 14 - F Doe | 7:00 AM | 11:00 AM | 20 - Shop and Equipment Maintenance | - | 4 | REG | $0.00 | Test | - | 0 | Test | - | - | 127 - Forest Maintenance | Approved | 09/09/2020 5:51 pm UTC | ||
52 | 9/2/2020 | Test | 14 - F Doe | 11:00 AM | 3:00 PM | 311 - Countertop - Slab | - | 4 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Kitchen 1 | Approved | 09/09/2020 5:51 pm UTC | ||
53 | 9/3/2020 | Test | 14 - F Doe | 1:00 PM | 3:00 PM | 321 - Island - Slab | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Kitchen 1 | Approved | 09/09/2020 5:51 pm UTC | ||
54 | 9/3/2020 | Test | 14 - F Doe | 7:00 AM | 1:00 PM | 311 - Countertop - Slab | - | 6 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Kitchen 1 | Approved | 09/09/2020 5:51 pm UTC | ||
55 | 9/4/2020 | Test | 14 - F Doe | 12:00 PM | 2:00 PM | 321 - Island - Slab | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Kitchen 1 | Approved | 09/09/2020 5:51 pm UTC | ||
56 | 9/4/2020 | Test | 14 - F Doe | 7:00 AM | 12:00 PM | 311 - Countertop - Slab | - | 5 | REG | $0.00 | Test | - | 0 | Test | - | - | 109 - Kitchen 1 | Approved | 09/09/2020 5:51 pm UTC | ||
57 | 143 - G Doe | Subtotal Hours : 38.5 | |||||||||||||||||||
58 | 8/31/2020 | Test | 143 - G Doe | 1:00 PM | 4:30 PM | 402 - Shower - Slab | - | 3.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
59 | 8/31/2020 | Test | 143 - G Doe | 7:30 AM | 12:00 PM | 301 - Vanity - Slab | - | 4.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
60 | 9/1/2020 | Test | 143 - G Doe | 11:30 AM | 2:30 PM | 211 - Backsplash - Slab | - | 3 | REG | $0.00 | Test | - | 0 | Test | - | - | 105 - Bunk Bath | Approved | 09/09/2020 5:51 pm UTC | ||
61 | 9/1/2020 | Test | 143 - G Doe | 2:30 PM | 3:30 PM | 402 - Shower - Slab | - | 1 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
62 | 9/1/2020 | Test | 143 - G Doe | 7:30 AM | 10:30 AM | 402 - Shower - Slab | - | 3 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
63 | 9/2/2020 | Test | 143 - G Doe | 2:00 PM | 4:00 PM | 402 - Shower - Slab | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 104 - Master 4 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
64 | 9/2/2020 | Test | 143 - G Doe | 7:30 AM | 9:00 AM | 301 - Vanity - Slab | - | 1.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
65 | 9/2/2020 | Test | 143 - G Doe | 9:00 AM | 12:00 PM | 402 - Shower - Slab | - | 3 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
66 | 9/3/2020 | Test | 143 - G Doe | 3:30 PM | 4:15 PM | 402 - Shower - Slab | - | 0.75 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
67 | 9/3/2020 | Test | 143 - G Doe | 7:00 AM | 9:00 AM | 402 - Shower - Slab | - | 2 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Master 2 Bath | Approved | 09/09/2020 5:51 pm UTC | ||
68 | 9/3/2020 | Test | 143 - G Doe | 9:00 AM | 3:30 PM | 301 - Vanity - Slab | - | 6.5 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
69 | 9/4/2020 | Test | 143 - G Doe | 12:15 PM | 4:00 PM | 601 - Tub Surround - Slab | - | 3.75 | REG | $0.00 | Test | - | 0 | Test | - | - | 101 - Camp Bath | Approved | 09/09/2020 5:51 pm UTC | ||
70 | 9/4/2020 | Test | 143 - G Doe | 7:15 AM | 11:15 AM | 402 - Shower - Slab | - | 4 | REG | $0.00 | Test | - | 0 | Test | - | - | 102 - Master Bathroom | Approved | 09/09/2020 5:51 pm UTC | ||
SUBMITTED TIME REPORT -- 083120 |