Copy rows as many there are 'slashes' in the cell and split out thecontent of that cell in the copied rows
Hello,
An action which I do mostly by hand, row for row, perhaps is possible to do automaticly.
In a sheet column A till Z, is in column F in some cases text registered with a 'slash' in between if more then one text occur in the specific cell.
If Cell F contains more textfields, and then there also slashes, then I split it out in identical copied rows, with only in column F the text as standalone separated part.
The basic row stays as it is, only if there are for example 3 slashes in column F then I insert 3 rows below this basic row, copy the complete row, and fill in cell F only that part of the text.
If there are no slashes then no copy action required.
For example.
Row.....ColumnF
2.......aa/bb/cc
3.......dd/ee
4.......ff
5.......gg/hh/ii
6.......jj
results then in
Row1....ColumnF
2.......aa/bb/cc
3.......aa
4.......bb
5.......cc
6.......dd/ee
7.......dd
8.......ee
9.......ff
10......gg/hh/ii
11......gg
12......hh
13......ii
14......jj
If somebody like to solve :)
Then I can stop doing it by hand.
regards, Johan
|