Transpose rows to columns

Hi,

Below is my table. I want to convert the rows to column.

I use Prepare recipe to covert rows in to columns. It perfectly converts and showing the results as expected output.

However after running the recipe, Out put dataset shows result as below. Unlike the results in receipe output datset creates some empty rows. Am i missing anything here or it is system issue?

I am expecting output to be shown all in one row.(Similar to recipe output).

Operating system used: Windows