Transpose Columns into Rows based on Unique Identifier for n columns

Hi,

I'm new to VBA and am struggling to find any solutions for this problem - I have a spreadsheet which contains about 10k rows and 21 columns. The data has identifiers in Column C and I'm trying to write some kind of VBA Code to transpose the data into a new sheet based on the identifier in Column C.

Below is how the data is set out for column C
C
1111111
1111111
1111111
1111111
1111111
1111112
1111113
1111113
1111113
1111113
1111113
1111113
1111113
1111113
1111114
1111114
1111115

The code I am trying to get is to copy and paste values into "Sheet 2" which goes down the columns and transposes until the ID in column C is different from the next one. The number of Ids in column C that will be the same ranges from 1 to 10. so it will look like the below (obviously with lots of columns added):
C
1111111
1111112
1111113
1111114
1111115

I have attached a copy of a sample of the spreadsheet that should make it clearer. I have only included 16 columns but there will be 21 but if there is a way of making this work for n-columns that would be amazing! I'm happy with having loads and loads of columns to work with...

Thanks!!

HI..

Can you reattach the sample workbook but this time include the desired result for that sample set on sheet2

Hi,

Thanks for coming back so quickly and apologies - that would have made things clearer! I've attached a file with the output in Sheet2.

Thank you very much!

Wow - that worked perfectly! Thanks so much!