Here's a generic dynamic sql statement to generate your pivot table. Keep in mind that if the list of distinct names is long, this will take a while to generate (i.e. don't run this on large tables)
create table #t1 (name varchar(20))
insert into #t1
select 'K' union all
select 'A' union all
select 'S' union all
select 'I' union all
select 'N' union all
select 'A' union all
select 'T'
--PIVOT
DECLARE @Colslist VARCHAR(MAX)
DECLARE @Cols TABLE (Head VARCHAR(MAX))
INSERT @Cols (Head)
SELECT DISTINCT Name
FROM #t1
SELECT @ColsList = COALESCE(@ColsList + ',[', '[') + Head + ']'
FROM @Cols t
EXEC ('SELECT *
FROM
(
SELECT a.name
FROM #t1 a
) t
PIVOT (min(Name) FOR Name IN (' + @ColsList + ')) PVT')