------------------------------------------------
Thanks For All Your Help
Windows 7
Excel 2010
Any codes I provide please try on a copy of your workbook first as these cannot be undone!
To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.
The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.