Splitting table by category then into groups of specific size

[Charles1234]

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.

Many Thanks!!

Many Thanks!!

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Splitting table by category into groups of specific size. [SOLVED]

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...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Charles1234]

Apologies about that, I was unaware of the rules.

Here is the link:

Splitting table by category into groups of specific size. [SOLVED]

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...

www.excelforum.com