Combine exports with different column orders
Your goal: Align ID, Team and Units before stacking two exports, preserving duplicate records and signed quantities.
Full task requirements
Enter one formula in G5. Combine the first export A2:D5 followed by the second export A9:D12. Return ID, Team and Units in that order, with no headings. The second export stores Units, Note, ID and Team. Omit a slot only when its ID is empty. Retain duplicate IDs, source order, signed units and numeric zero. Return No records in one cell when both blocks have no active ID.
Different column orders; signed units and empty-ID slotsPrepare export A
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 |
Step 1 of 3
Prepare export A
Rules for this step
Choose every nonempty ID slot. Duplicates and zero or signed units remain records. Then identify the source columns for the three output fields.