Splitting table by category into groups of specific size.

Hello all, I'm new to VBA and I'm struggling with solving a problem. I have spent days searching for a solution and now I'm stuck!!!
Any help would be greatly appreciated.

Table 1 is filled and can be any length. There is a finite number of test types. Each test type can have any number of samples (ID). I want to create a new table (Table 2) that splits test type into groups of three for all test types and leaves blank any slots within a group of specific test type that aren't filled.

Please see attached file.

Many Thanks!!

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for yu this time: https://www.mrexcel.com/board/thread...-size.1194456/)

Please Login or Register  to view this content.

see sheet "TEST"

You are very welcome.

Thank you for the feedback and rep.