Do you need 2nd Sheet?
If not Please try formula
Combine A2 drag to the right
Formula:
=IF(COLUMNS($A2:A2)<3,TRIM(MID(SUBSTITUTE('Output by Item Name 1 Column'!$A2," ",REPT(" ",20)),COLUMNS($A2:A2)*20-19,20)),INDEX('Output by Item Name 1 Column'!2:2,COLUMNS($A2:A2)-1))
Or Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Split Column by Delimiter" = Table.SplitColumn(Source, "Name", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"First Name", "Last Name"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Item 1", Int64.Type}})
in
#"Changed Type"
Bookmarks