Fill column A with row number.
Highlight column A, select menu Restructure: Split Columns to open dialog.
Click OK with default settings.
Active result sheet, add a new column col C.
Click the lock and choose change parameters to open dialog, click OK directly.
==> Only one value in the 1st result column, and column C fills with result data.
Fixed in Origin 2024b.