Hi,
I want to break down every row into multiple row where a part of it would be carried forward from the parent and the last column would be the transpose of the remaining part of the parent row. Here's an example.
Table 1 (static column A, B. variable column: C, D, E, F...):
<tbody>
</tbody>
I would want it to look like:
Table 2:
<tbody>
</tbody>
There are almost a 1000 rows in my original table with the variable part of the rows ranging from 1 to 10 columns. This means that every row's static part can have 1-10 copies with only the last column changing. I hope the problem makes sense. I have looked at other topics in the forum and have found similar topics (transposing rows into single column), however I didn't find one with variable data in the rows, and where they dont have a static part that gets copied. Please help!
Thanks,
Sonik
I want to break down every row into multiple row where a part of it would be carried forward from the parent and the last column would be the transpose of the remaining part of the parent row. Here's an example.
Table 1 (static column A, B. variable column: C, D, E, F...):
Column A | Column B | Column C | Column D | Column E | Column F |
abc | def | ABC | DEF | ||
lmn | pqr | LMN | PQR | XYZ |
<tbody>
</tbody>
I would want it to look like:
Table 2:
Column A | Column B | Column C | Column D | Column E | Column F |
abc | def | ABC | |||
abc | def | DEF | |||
lmn | pqr | LMN | |||
lmn | pqr | PQR | |||
lmn | pqr | XYZ |
<tbody>
</tbody>
There are almost a 1000 rows in my original table with the variable part of the rows ranging from 1 to 10 columns. This means that every row's static part can have 1-10 copies with only the last column changing. I hope the problem makes sense. I have looked at other topics in the forum and have found similar topics (transposing rows into single column), however I didn't find one with variable data in the rows, and where they dont have a static part that gets copied. Please help!
Thanks,
Sonik