Excel macro -Split semicolon separated entries to new rows

[AT BABU]

I currently have this data in a sheet

Sl No	Date	Reviewed by	Assignment	Pole Number	Feature Class	Attribute	Error Category	Observation
1	8/2/2019	Bob.B	Batch1	101039656	Cross-Arm	Rotation	Attribute	Arm is reversed, causing primaries to cross; Delete riser.
2	8/2/2019	Bob.B	Batch1	101039656	Cross-Arm	Rotation	Attribute	Arm is reversed, causing primaries to cross; Delete riser.

What I want to do is split the semicolon separated entries in the third column and insert in new rows like below:

Sl No	Date	Reviewed by	Assignment	Pole Number	Feature Class	Attribute	Error Category	Observation
1	8/2/2019	Bob.B	Batch1	101039656	Cross-Arm	Rotation	Attribute	Arm is reversed, causing primaries to cross;
2	8/2/2019	Bob.B	Batch1	101039656	Cross-Arm	Rotation	Attribute	Delete riser.
3	8/2/2019	Bob.B	Batch1	101039656	Cross-Arm	Rotation	Attribute	Arm is reversed, causing primaries to cross;
4	8/2/2019	Bob.B	Batch1	101039656	Cross-Arm	Rotation	Attribute	Delete riser.

 

[AT BABU]

Thank you Peter It working instead in the line above code

No I have more then 2, but in this data only items

 

[Peter_SSs]

Thank you Peter It working instead in the line above code

You're welcome.