alvaro_v_b
New Member
- Joined
- Mar 29, 2016
- Messages
- 2
Hello Everybody!
I have a difficult task ahead and I am not sure if what I want to do is possible to be done in an authomatic way.
I have a data base with several fields/columns: A, B, C, D. In the last one (D), each field contains several words separated by a delimiter.
What I want is, for each row to generate as many rows as delimited words in column D, filling columns A, B and C with the same content of the original row.
For instance, I want to automaticly transform something like this:
<tbody>
</tbody>
Into something like this:
<tbody>
</tbody>
(In the real case I have many more rows)
Does anybody know if this is possible in Excel?
THANK YOU SO MUCH IN ADVANCE FOR YOUR HELP!!
Alvaro
I have a difficult task ahead and I am not sure if what I want to do is possible to be done in an authomatic way.
I have a data base with several fields/columns: A, B, C, D. In the last one (D), each field contains several words separated by a delimiter.
What I want is, for each row to generate as many rows as delimited words in column D, filling columns A, B and C with the same content of the original row.
For instance, I want to automaticly transform something like this:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> | 12 | 13 |
<tbody> </tbody> | ||||
65 | 12 | 02 |
<tbody> </tbody> |
<tbody>
</tbody>
Into something like this:
ShapeKey | Class | Subclass | Products |
1104 | 12 | 13 | Parade floats |
1104 | 12 | 13 | Motor cars |
1104 | 12 | 13 | Mobile laboratories |
1104 | 12 | 13 | Motor graders |
1104 | 12 | 13 | Trucks for liquid manure |
65 | 12 | 02 | Trolleys |
65 | 12 | 02 | Wheel carriers |
65 | 12 | 02 | Dollies |
<tbody>
</tbody>
(In the real case I have many more rows)
Does anybody know if this is possible in Excel?
THANK YOU SO MUCH IN ADVANCE FOR YOUR HELP!!
Alvaro