How to generate multiple output tables on SQL server of same schema based on a column

[dizy_11]

Hi,

I want to generate multiple tables in SQL server from same table based on different values in column "Test".

I have attached the sample input and output tables.

Different output table should be generated in SQL server as per values in column "Test".

Do anybody know how to do this directly in a output tool by adding stored procedure for these tests in it.

Thanks in advance.

[Qiu]

@dizy_11 
I hope I get you correctly.