Dynamically Transposing and Deleting Rows to Columns

Hello,

I'm really new to the world of VBA, and would appreciate some help. I have data that needs to be transposed from rows to columns within the same spreadsheet.(the rows that are transposed can then be deleted. ) The ranges would need to be set dynamically because the number of rows will vary, but each row is associated with unique id in row E - that's repeated, except for the header row. Only 4 columns will actually need to be repeated, and each inserted group of 4 (how many groups of 4 will depend on row count for each unique id in column E). These groups will need to be inserted BEFORE the last 3 columns.

I spent a lot of time trying to wrap my head around this, and just not getting anywhere. Please help!