Hi there,
I have a problem in excel which seems easy enough on the face of it, but despite staring at it for hours and hours now I still haven't much of a clue of how to solve it!
I feel a bit cheeky being new here and asking for help, but really I have nowhere else to go! (Sorry to be a pain)

I need to create a worksheet that takes an existing sheet and manipulates it to a more desirable outcome.

The sheet must recognise when a cell in column A has an entry that the remaining contents of that row, and all rows beneath it in column B must be copied onto a new line, until reaching a blank row.

For example

A1 B1 C1
A2 B2 C2
A3

A5 B5 C5

Should become the following, on my second sheet:

A1 B1 C1
A1 B2 C2
A2 B1 C1
A2 B2 C2
A3 B1 C1
A3 B2 C2

A5 B5 C5

Any help would be appreciated! Please!