transposing accourding to values in a cell?

hello all
I am using excel in Office 365
I have columns A to D in my excel sheet.
Column A has a value and some blank cells on various lines: I want to transpose the values in column C and D on the first line until column A changes.
in the attachment, line 3 has the transposed values of column C and D, until the Value in column A changes.
and when it does, I need the same for that record: meaning, column C and D until the next value of A changes, must be transposedAttachment 810999Attachment 811006