Split table into several tables based on condition

[cutehappybear]

Hello, I want to split the following table:

Type	Data
A	123456
A	4535435
A	343242
B	988798797
B	87876
B	713123
C	23424
C	32432

Into the following 3 tables:

A	123456
A	4535435
A	343242

B	988798797
B	87876
B	713123

C	23424
C	32432

However, I could have more than 3 types. I want this to be dynamic/automatized for the number of types that I have.

I want to output to tables "in memory" that I can then use in other tools, and not to files.

How could I do it? Thank you!

[Qiu]

@cutehappybear 
We can use the filter tool to split the data stream but it will not be dynamic as you said.

Would loev to see if there is apppoach can do it.

It can be easy to write file though.

[gabrielvilella]

I'm assuming that you have a specific rule that you need to apply depending on the type. You need to create all the possible rules, separating the data using filters as @Qiu mentioned. If there is no data for a certain type, nothing will happen. If in the end you combine all them into a single table, you can have all those rules and filters within a macro so your workflow will look cleaner.