Rocker Panel Parts Sheet
Budget: ₹12,500 – ₹37,500 INR
I have a raw master spreadsheet containing hundreds of body-panel SKUs for multiple makes and years. I need that data trimmed down to just the rocker panels that fit:
• Ford F-150, model years 2008 and newer
• Dodge Ram 1500 pickup (all years)
• GMC pickups (all years)
Once the list is filtered, please:
1. Keep only two columns—Part number and Description—exactly as they appear in the source.
2. Re-sort the remaining rows by vehicle type so the F-150 entries come first, followed by Ram 1500, then GMC.
3. Deliver the finished file as a Google Sheet, ready for import into our purchase-order system.
No additional formatting or extra columns are required; the goal is a clean, concise list I can copy straight into a PO. If any part numbers appear more than once, consolidate them into a single row and append “(duplicate)” to the description so I can spot overlaps quickly.
Access to the current spreadsheet will be shared immediately after project start.
• Ford F-150, model years 2008 and newer
• Dodge Ram 1500 pickup (all years)
• GMC pickups (all years)
Once the list is filtered, please:
1. Keep only two columns—Part number and Description—exactly as they appear in the source.
2. Re-sort the remaining rows by vehicle type so the F-150 entries come first, followed by Ram 1500, then GMC.
3. Deliver the finished file as a Google Sheet, ready for import into our purchase-order system.
No additional formatting or extra columns are required; the goal is a clean, concise list I can copy straight into a PO. If any part numbers appear more than once, consolidate them into a single row and append “(duplicate)” to the description so I can spot overlaps quickly.
Access to the current spreadsheet will be shared immediately after project start.