Hello. I need help with this issue. I need to add UNIQUE Value from the below cells comma separated unit there is an empty cell. This is required from product upload. I have bold the data which I need by VBA.
After row 10 there is an empty cell. So the script will run from Row 3 - 12 and should put the data in Row 2. Then again from 14 - 27 and put the data in Row 13.
After row 10 there is an empty cell. So the script will run from Row 3 - 12 and should put the data in Row 2. Then again from 14 - 27 and put the data in Row 13.
| Position | Attribute 1 name | Attribute 1 value(s) | Attribute 1 visible | Attribute 1 global | Attribute 2 name | Attribute 2 value(s) | Attribute 2 visible | Attribute 2 global |
0 | Size | S, M, L, XL, 2XL | Colour | Black, Navy | 1 | 1 | ||
1 | Size | S | 1 | 1 | Colour | Black | 1 | 1 |
2 | Size | M | 1 | 1 | Colour | Black | 1 | 1 |
3 | Size | L | 1 | 1 | Colour | Black | 1 | 1 |
4 | Size | XL | 1 | 1 | Colour | Black | 1 | 1 |
5 | Size | 2XL | 1 | 1 | Colour | Black | 1 | 1 |
6 | Size | S | 1 | 1 | Colour | Navy | 1 | 1 |
7 | Size | M | 1 | 1 | Colour | Navy | 1 | 1 |
8 | Size | L | 1 | 1 | Colour | Navy | 1 | 1 |
9 | Size | XL | 1 | 1 | Colour | Navy | 1 | 1 |
10 | Size | 2XL | 1 | 1 | Colour | Navy | 1 | 1 |
| Size | 3XL | 1 | 1 | Colour | Black/Graphite | 1 | ||
| Size | S | 1 | 1 | Colour | Black/Graphite | 1 | ||
| Size | M | 1 | 1 | Colour | Black/Graphite | 1 | ||
| Size | L | 1 | 1 | Colour | Black/Graphite | 1 | ||
| Size | XL | 1 | 1 | Colour | Black/Graphite | 1 | ||
| Size | 2XL | 1 | 1 | Colour | Black/Graphite | 1 | ||
| Size | 5XL | 1 | 1 | Colour | Black/Graphite | 1 | ||
| Size | S | 1 | 1 | Colour | Navy/Graphite | 1 | ||
| Size | M | 1 | 1 | Colour | Navy/Graphite | 1 | ||
| Size | L | 1 | 1 | Colour | Navy/Graphite | 1 | ||
| Size | XL | 1 | 1 | Colour | Navy/Graphite | 1 | ||
| Size | 2XL | 1 | 1 | Colour | Navy/Graphite | 1 | ||
| Size | 3XL | 1 | 1 | Colour | Navy/Graphite | 1 | ||
| Size | 5XL | 1 | 1 | Colour | Navy/Graphite | 1 |
