English | Japanese (日本語) | Spanish (español) | Portuguese (Português)
Join two table data with common KEY value
Merge two EXCEL tables of different formats to generate a new table. Merge is performed after determining the character match of the specified column.
For example, compare the second column of Table 1 with the second column of Table 2 and add to Table 1 if the characters match.
[ Example ]
Table 1 →Set "Column 2" to KEY.
|
Table 2 →Set "Column 2" to KEY.
|
Column 1 | Column 2 | Column 3 | Column 1 | Column 2 |
---|---|---|---|---|
AKB48 | Anna Iriyama | 1995.12.03 | Team A | Anna Iriyama |
AKB48 | Minami Minegishi | 1992.11.15 | Team K | Minami Minegishi |
AKB48 | Rena Kato | 1997.07.10 | ||
AKB48 | Rina Okada | 1999.07.27 |