Transpose data to columns from rows keeping unique data together

So basically i have one single column with groups of information in it, each bit of info is separated by a space (1 row). I need a macro to move this info into 3 columns, keeping the matching information together in a row...

have attached an example of what i mean since i probably make no sense

thanks!Macro example.xlsx

Alter if needed.

Sub test()
    Dim i As Long
    For i = 1 To Columns(1).SpecialCells(2).Areas.Count
        With Columns(1).SpecialCells(2).Areas(i)
            Cells(i, 3).Resize(, .Rows.Count).Value = _
            Application.Transpose(.Value)
        End With
    Next
    Cells(1, 5).Resize(i - 1).NumberFormat = "0"
    Columns("c:e").AutoFit
End Sub

awesome! that worked perfectly thank you

if you don't mind, could you quickly explain how this macro works? i may have similar data later but with slight changes so might need to alter it if i can

1)

Columns(1).SpecialCells(2).Areas

This gives you the areas(block of range) that has constant values. 2 = xlConstants.
You will see the range adding one line

MsgBox Columns(1).SpecialCells(2).Areas.Address

2) Loop thrugh 1) and output each range to other range transposing column to row(s).

Any question?