Append Records to a fixed number of columns using dynamic data
[], pivot are hints it's MS SQL. Then

select [Cost Center]
  , [Node1] = max(case rn when 1 then [Function] end)
  , [Node2] = max(case rn when 2 then [Function] end)
  , [Node3] = max(case rn when 3 then [Function] end)
  , [Node4] = max(case rn when 4 then [Function] end)
  , [Node5] = max(case rn when 5 then [Function] end)
  , [Node6] = max(case rn when 6 then [Function] end)
from (
    select [Cost Center],[Function]
     , rn = row_number() over(partition by [Cost Center] order by [Function])
     --  or may be ..order by [id]) depending on column sequence you need.
    from youTable) t
group by [Cost Center];