I have a sheet done by a coworker where each row looks like this (aa dd ee ff are all within the same cell):
A B C
aa bb cc
dd
ee
ff
The values in column A are a continuous string of expressions of identical length, alligned within the column by setting the column width.
I need to come up with something like this:
A B C
aa bb cc
dd bb cc
ee bb cc
ff bb cc
Essentially generate one separate row for each expression in column A and fill the rows with the various values of A together with the corresponding values in the other columns.
All my VBA achieved was generating the correct number of empty lines plus splitting the string of expressions into rows with one expression per cell.
Any ideas how to work on here?
Am I approaching this completely wrong?
I would highly appreciate an adaptable macro approach since there's a huge number of similar sheets in my company that need serious streamlining.
A B C
aa bb cc
dd
ee
ff
The values in column A are a continuous string of expressions of identical length, alligned within the column by setting the column width.
I need to come up with something like this:
A B C
aa bb cc
dd bb cc
ee bb cc
ff bb cc
Essentially generate one separate row for each expression in column A and fill the rows with the various values of A together with the corresponding values in the other columns.
All my VBA achieved was generating the correct number of empty lines plus splitting the string of expressions into rows with one expression per cell.
Any ideas how to work on here?
Am I approaching this completely wrong?
I would highly appreciate an adaptable macro approach since there's a huge number of similar sheets in my company that need serious streamlining.
