jazzista
Member
- Joined
- Jan 4, 2017
- Messages
- 50
- Reaction score
- 0
- Points
- 6
- Excel Version(s)
- Office 365
Main And Sub | Account Description | Sum of Net Amount |
220 10 | Contract Labor | 668,463.40 |
220 15 | Catering | 7,928.46 |
220 20 | Trans - Air Travel | 1,496.00 |
Main And Sub | Account Description | Sum of Net Amount |
215 10 | Capitalized Interest | 115,997.00 |
220 10 | Contract Labor | 668,463.40 |
220 100 | Drilling Unit | 16,421.47 |
220 110 | Directional Drilling Services | 2,176,608.69 |
220 115 | Cutting Handling Services | 299,504.68 |
220 130 | Drill Pipe (Rentals) | 163,172.72 |
220 145 | Drilling Jars | 30,544.40 |
220 15 | Catering | 7,928.46 |
220 165 | Casing Spears | 2,110.77 |
220 175 | Fugro Sonar | 18,166.54 |
220 195 | Electric Line Service | 31,149.81 |
220 20 | Trans - Air Travel | 1,496.00 |
Main And Sub | Account Description | Sum of Net Amount |
220 10 | Contract Labor | 668,463.40 |
220 15 | Catering | 7,928.46 |
220 20 | Trans - Air Travel | 1,496.00 |
Hi Bob: Good morning. I neeed to sort by Acct number and my table is currently sorting out of sequence. It should sort like this. Any help is greatly appreciate it. Thank you so much
Main And Sub Account Description Sum of Net Amount 220 10 Contract Labor 668,463.40 220 15 Catering 7,928.46 220 20 Trans - Air Travel 1,496.00
= Table.AddColumn(#"Changed Type", "ToSort", each Text.Combine(List.Transform(Text.Split([Main And Sub], " "), each Text.PadStart(_, 3, "0"))), type text)