Dear all,
I have a spread sheet with a list of 12,251 rows and 317 columns. Then I have another list of 78 rows and 2 columns.
The two lists have the first column in common, as below
table 1
<tbody>
</tbody>
table 2 (total of 78 rows)
<tbody>
</tbody>
I need to create a new table (3) made of the 78 rows of table 2 and the corresponding 317 columns taken from table 1.
table 3
<tbody>
</tbody>
Thanks for the help!
Amanda
I have a spread sheet with a list of 12,251 rows and 317 columns. Then I have another list of 78 rows and 2 columns.
The two lists have the first column in common, as below
table 1
heading 1 | heading 2 | heading 3 | heading 4 |
1. | S | 3 | jk |
2. | D | 89 | 9N |
3. | V | 34 | 9HJ |
..... | ... | .... | ... |
482. | K | 0 | 7H |
.... | ... | .... | ... |
2009. | BN | 54 | 9 |
.... | ..... | ... | .... |
12,251. | LO | 67 | P |
<tbody>
</tbody>
table 2 (total of 78 rows)
heading 1 |
3. |
482. |
2009. |
8220. |
102928. |
<tbody>
</tbody>
I need to create a new table (3) made of the 78 rows of table 2 and the corresponding 317 columns taken from table 1.
table 3
heading 1 | heading 2 | heading 3 | heading 4 |
3. | V | 34 | 9HJ |
482. | K | 0 | 7H |
2009. | BN | 54 | 9 |
102928. | LO | 67 | P |
<tbody>
</tbody>
Thanks for the help!
Amanda
Last edited: