I need to include cell content within Table1. Table1 is a mix of cells - some merged some not. Table2 will only have certain cell content of Table1.
Example:
Table1
R1C1C2C3 (Header Row)
R2C1 | R2C2 | R2C3
R3C1 | R3C2 | R3C3
R4C1C2C3 (Header Row)
Table2
R1C1C2C3 (Merged Header Row)
R2C1 | R2C2 |
R3C1 | | R3C3
R4C1C2C3 (Merged Header Row)
When I am trying to take the {excerpt} of Table1 the information that I would like have included is that shown in Table2. In this fashion I would only need to update the information one time on Table1 with the update reflected in Table2 dynamically (upon user refreshing page).