Anything in Excel that would put the attached into three columns

16Teams 

A simple lookup by index should do the job.  Given an index column 'k' for the output table and naming the 2-column input table 'data', the formula

= INDEX(data, {1,2,1} + 2*(k-1), {1,1,2})

would return the data in the layout required.

Hi 16Teams

Kindly note that there are two different solution for your query. Attached is workbook for your ready reference.

Solution 01 - Manual approach 

1. Apply if function copy the above cell value.

2. Copy & paste the data as values

3. Remove the blank delete the blank cell by apply the filter value is null/blank

Solution 02 - Recommended [Power Query]

You can use Power Query to clear your data and shape it as you need

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Conditional Column" = Table.AddColumn(Source, "Custom", each if [Column3] = null then [Column1] else null),
    #"Filled Down" = Table.FillDown(#"Added Conditional Column",{"Custom"}),
    #"Filtered Rows" = Table.SelectRows(#"Filled Down", each ([Column3] <> null)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Column2"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Column1", "Custom", "Column3"})
in
    #"Reordered Columns"

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.