Columns of sql table is to be inserted to another table row wise

Question

I'm using sql R2 server. And i want to, Columns of sql table is to be inserted to another table row wise. Something like below. Please help me out here. Sorry my English is not so proper. I have attached screenshot here.

Here is my table :

Customer id     Member Code     Account Type

C000100000003   A0001000000003  SB

000100000007    R0001000000001  SB

C000100000010   R0001000000001  SB

C000100000007   R0001000000002  SB

And i want in the format like this

Customer id     Member Code     Account Type     Customer id     Member Code    Account Type    Customer id     Member Code     Account Type

C000100000003   A0001000000003  SB               C000100000003   A0001000000003  SB              C000100000003   A0001000000003   SB     

000100000007    R0001000000001  SB               C000100000003   A0001000000003  SB              C000100000003   A0001000000003   SB     

C000100000010   R0001000000001  SB               C000100000003   A0001000000003  SB              C000100000003   A0001000000003   SB     

C000100000007   R0001000000002  SB               C000100000003   A0001000000003  SB              C000100000003   A0001000000003   SB     

Thanks

Answer 1

SELECT *
INTO myNewTable
FROM myOldTable