Hello,
I have an excel document with 7000 rows
I need to insert a row after certain text. The problem is that there are multiple texts that I want to separate.
For example:
Column A
Test A
Test B
Test C:Yellow
Test C:Green
Test C:Blue
Test D:Lake
Test D:Ocean
Test E
Test F
Basically what I want to do is insert a ROW after A, B, C, D, E, F
It will look like this
Column A
Test A
Test B
Test C:Yellow
Test C:Green
Test C:Blue
Test D:Lake
Test D:Ocean
Test E
Test F
If there is a way to maybe use the semicolon to help determine that would be easier too, because my data has a semicolon if there are multiple types or no semicolon if its just single.
Please let me know what I can do. I am a beginner.
Thank you!
I have an excel document with 7000 rows
I need to insert a row after certain text. The problem is that there are multiple texts that I want to separate.
For example:
Column A
Test A
Test B
Test C:Yellow
Test C:Green
Test C:Blue
Test D:Lake
Test D:Ocean
Test E
Test F
Basically what I want to do is insert a ROW after A, B, C, D, E, F
It will look like this
Column A
Test A
Test B
Test C:Yellow
Test C:Green
Test C:Blue
Test D:Lake
Test D:Ocean
Test E
Test F
If there is a way to maybe use the semicolon to help determine that would be easier too, because my data has a semicolon if there are multiple types or no semicolon if its just single.
Please let me know what I can do. I am a beginner.
Thank you!