Excel File Processing Tool
Upload three Excel files to merge and process data according to specified rules
Instructions
- File 1: Based on column 3 value (BO or PO), extract data from column 10 or 8 respectively to column 1. Keep column 2 data in column 2, and column 6 data in column 3.
- File 2: Match column 2 data with new file column 1, then sum columns 4-11 and place result in new file column 4.
- File 3: Match column 2 data with new file column 1, then place column 5 data in new file column 5.
- Final Step: Sum columns 4 and 5 to create column 6 in the new file.
- Filter File 1 data by BO/PO value in column 3 before processing.
File 1 (Main Data)
Click or drag to upload File 1
Excel files only (.xlsx, .xls, .csv)No file selected
File 2 (Sum Data)
Click or drag to upload File 2
Excel files only (.xlsx, .xls, .csv)No file selected
File 3 (Additional Data)
Click or drag to upload File 3
Excel files only (.xlsx, .xls, .csv)No file selected
No comments:
Post a Comment