Mikeyd1,
In the future you should start your own new Post.
Thanks for the workook.
Please post another workbook with worksheet utf8BQ2j containing just the raw data in column A, just the way you receive it, and beginning in column C, row 1, the resulting format for three of the groups from column A.
Bookmarks