Combine exports with different column orders
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.