Transpose arrays into Rows

I am currently using the following VBA script to transpose a comma delimited array, from the "Input" worksheet to the "Database (output)" worksheet of an excel file.

Please Login or Register  to view this content.

It currently transposes the array into a single column with X Rows.
I would like to transpose the array into a single row with X Columns.

Current Results

Please Login or Register  to view this content.

Needed Results

Please Login or Register  to view this content.

Additionally, I need this to be done for each cell in the [A] Column of the "Input" worksheet, that contains data.
(There will be more then just the two shown in the attached excel file.

EXAMPLE EXCEL SHEET.
TEST EXCEL FILE.xlsx

What is the best way of accomplishing this task.
(I am a bit new to VBA coding however am very interested in learning how to accomplish these tasks!)

I greatly appreciate any and all help with this issue.
Thank you!

It worked perfectly! Thank you.

Do you mind answering a few questions about the script so I can better understand it?

Please Login or Register  to view this content.

What does .End(xlUp) do?