Transposing Columns to Rows

[cradd64]

I have a spreadsheet with thousands or rows od data which can be grouped into Personal Id Number as below picture1. I would like to transpose two columns to rows at the start of each persons Personal Id Number as in picture 2 or ideally as in picture 3 but despite searching I can not find macro which will do this so any help or thoughts would be gratefully received.

image 1

Image 2

Image 3

 

[Fluff]

how do I reply without including your original post because for the life of me I can't work it out

Just use the reply window at the bottom of the thread.