Members lesson 30
Final project
Turn a messy import into a cleaned, filtered, and ranked report.
What you will practice
- Clean and split imported text
- Format a report value for display
- Filter and rank a cleaned report
Lesson preview
Starting tableImport report
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Raw name | Imported code | Amount | Imported date | Clean name | Region | Status | Amount | Display | Ready report | |
| 2 | ana chen | East-Ready | 125 | 2024-02-01 | 125 | ||||||
| 3 | Bo Diaz | West-Hold | 80 | 2024-02-03 | Bo Diaz | West | Hold | 80 | |||
| 4 | Cam Lee | East-Ready | 210 | 2024-02-04 | Cam Lee | East | Ready | 210 | |||
| 5 | Dee Hall | North-Ready | 95 | 2024-02-05 | Dee Hall | North | Ready | 95 | |||
| 6 | Eli Moss | West-Ready | 160 | 2024-02-06 | Eli Moss | West | Ready | 160 | |||
| 7 | Fay Reed | North-Hold | 140 | 2024-02-07 | Fay Reed | North | Hold | 140 | Ready report by amount | ||
| 8 |