how to sql query transpose

Question

Dear All Friend Please find result

 

Date	Name	Age	Category
6-Oct-19	Name_1	12	1
6-Oct-19	Name_2	12	2
7-Oct-19	Name_3	3	1
7-Oct-19	Name_4	4	1
10-Oct-19	Name_5	5	2
10-Oct-19	Name_6	5	2
10-Oct-19	Name_7	6	2
10-Oct-19	Name_8	12	3
10-Oct-19	Name_9	32	3
5-Oct-19	Name_10	50	4
5-Oct-19	Name_11	34	4
5-Oct-19	Name_12	23	4
5-Oct-19	Name_13	1	5
5-Oct-19	Name_14	2	5
5-Oct-19	Name_15	1	5

 

 

 

 

 

Output Result

 

1	2	3	4	5
Name_1 12         6-Oct-19	Name_2 12          6-Oct-19	Name_8 12 10-Oct-19	Name_10 50 5-Oct-19	Name_13 1 5-Oct-19
Name_3 3 7-Oct-19	Name_5 5 10-Oct-19	Name_9 32 10-Oct-19	Name_11 34 5-Oct-19	Name_14 2 5-Oct-19
Name_4 4 7-Oct-19	Name_6 5 10-Oct-19		Name_12 23 5-Oct-19	Name_15 1 5-Oct-19
	Name_7 6 10-Oct-19

 

 

 

 

 

 

 

 

use 

SQL Server Query