This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
Problem description & analysis:
Here are two Excel "named ranges", which are Events1 and Events2 respectively. Starting from the 2nd row, both can be regarded as a table with column headers and some of their headers are the same.
Task: Reference names of the two "named ranges" and combine the two tables; display a field that does not exist under the current range name as empty.
Solution:
Use SPL XLL to do this:
=spl("=?1.to(3,).($[Events1]|~.m(1,2,3,0,4))|?2.to(3,).($[Events2]|~.m(1,0,0,2,3))",Events1,Events2)
As shown in the picture below:
Explanation:
to(3,) function gets members from the 3rd to the last. m()function gets multiple members according to their positions; 0 means null. ~ is the current member, and $[] represents a string.
This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
Judith-Excel-Sharing | Sciencx (2024-07-18T03:19:00+00:00) #28 — Combine Two Tables With Different Column Headers. Retrieved from https://www.scien.cx/2024/07/18/28-combine-two-tables-with-different-column-headers/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.