Using scripting dictionary to add contiguous group of items from non contiguous range

This one has me stumped.

See attached workbook:
Using a dictionary I would like to copy the values in Sheet1 column C to Sheet 2 column A based upon the contiguous groups of strings in Sheet1 column A. I.E. Sheet1 C1 will be copied to Sheet2 A1, Sheet1 C7:C9 will be transposed to Sheet2 A2:C2, etc. (See sheet2 for results)

Note: I know many other ways of doing this, I am specifically looking to see if this is possible using a dictionary.

Code I have so far

Please Login or Register  to view this content.

If you need any other information please let me know. Thank you.

Try this version to see if it gets the result you're looking for:

Please Login or Register  to view this content.

I find post#1 somewhat puzzling.
As noted, there's various ways to produce the result.
There's also various ways to use one or more of the properties of the dictionary object.
All of the things a dictionary can do can be done in other ways. Dictionary is often more convenient and sometimes faster. It's neither of these in the example you give.
There's a code below including a dictionary but making no use of it because its unclear which of its properties are important to you. If you'd like to be more specific about which dictionary properties you want there should be little problem in including them, but for what purpose?

Please Login or Register  to view this content.

Thank you WHER. Exactly what I was looking for.