Dear All,
I have a table with 26 Columns and 2045 Row, I need to add rows with the same exact data but depending on the number available in COL2
meaning:
If I have number 2 in COL2 then I need to add ONE row with the same exact data except having COL2 for the new added rows is BLANK
If I have number 3 in COL2 then I need to add TWO rows with the same exact data except having COL2 for the new added rows is BLANK
If I have number 1 in COL2 then NO rows to Add.
If COL2 = Blank , NO rows to Add.
If COL2 = 4 then 3 rows need to be added wit the same exact data except COL2 is black in the 3 added rows.
IF COL2 = 10 then 9 rows need to be added with the same exact data except COL2 will be blank for the new 9 rows
If there is anything in COL2 other than number nothing to add (I will do this manually as they are few).
someone told me to use Macro (but I don't know how to use Macros) if this is the solution can someone explain how.
Thank you so much for any help suggested.
<tbody>
</tbody>
RESULT:
<tbody>
</tbody>
I have a table with 26 Columns and 2045 Row, I need to add rows with the same exact data but depending on the number available in COL2
meaning:
If I have number 2 in COL2 then I need to add ONE row with the same exact data except having COL2 for the new added rows is BLANK
If I have number 3 in COL2 then I need to add TWO rows with the same exact data except having COL2 for the new added rows is BLANK
If I have number 1 in COL2 then NO rows to Add.
If COL2 = Blank , NO rows to Add.
If COL2 = 4 then 3 rows need to be added wit the same exact data except COL2 is black in the 3 added rows.
IF COL2 = 10 then 9 rows need to be added with the same exact data except COL2 will be blank for the new 9 rows
If there is anything in COL2 other than number nothing to add (I will do this manually as they are few).
someone told me to use Macro (but I don't know how to use Macros) if this is the solution can someone explain how.
Thank you so much for any help suggested.
| COL1 | COL2 | COL3 | COL4 | COL5 | COL6 | COL7 | COL8 | COL9 | COL10 |
| A | 2 | B | C | D | E | F | G | H | I |
| X | 3 | X | X | X | X | X | X | X | X |
| Y | 1 | Y | Y | Y | Y | Y | Y | Y | Y |
| F | 4 | F | F | F | F | F | F | F | F |
| D | 7(1ml) | D | D | D | D | D | D | D | D |
| B | B | B | B | B | B | B | B | B |
<tbody>
</tbody>
RESULT:
| COL1 | COL2 | COL3 | COL4 | COL5 | COL6 | COL7 | COL8 | COL9 | COL10 |
| A | 2 | B | C | D | E | F | G | H | I |
| A | B | C | D | E | F | G | H | I | |
| X | 3 | X | X | X | X | X | X | X | X |
| X | X | X | X | X | X | X | X | X | |
| X | X | X | X | X | X | X | X | X | |
| Y | 1 | Y | Y | Y | Y | Y | Y | Y | Y |
| F | 4 | F | F | F | F | F | F | F | F |
| F | F | F | F | F | F | F | F | F | |
| F | F | F | F | F | F | F | F | F | |
| F | F | F | F | F | F | F | F | F | |
| D | 7(1ml) | D | D | D | D | D | D | D | D |
| B | B | B | B | B | B | B | B | B |
<tbody>
</tbody>
