How to split data from column to multiple columns
String splitting functions return the data in rows, because handling dynamic columns is a lot more complex in SQL because that's not really what SQL is supposed to be used for.

To get data in columns, you can use for example pivot or max + case, something like this:

select
  max(case when ItemNumber = 1 then Item end), 
  max(case when ItemNumber = 2 then Item end), 
  max(case when ItemNumber = 3 then Item end), 
  max(case when ItemNumber = 4 then Item end), 
  max(case when ItemNumber = 5 then Item end)
from
  [dbo].[DelimitedSplit8K]('Masha/Sasha/Nadia/Loki','/')


You could also create a function / SQL that uses charindex + substring to find the places of the separator and just select the 5 pieces directly without creating them into rows.

If you need to handle dynamic amount of columns, then you'll have to create the SQL dynamically and calculate the maximum number of separators in your data first.