Using list value as column name when transposing

Hi,

I’m trying to transpose the following table from SQL Server:

Into this table (first row as column name):

Using this article, I’m able to transpose the table into (column name like A-G): https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.html

But for further use the column name must be the first row, not A-G.

How can I set first row as column name?

I’ve tried using the AttributeCreator with values from a second list, and exposing the dynamic attributes afterword’s, but I can’t get it to work..

Attribute name from list example:

New Attribute = @Value(_testpara_attri{0}._testpara_value)

Attribute value = attrs{0}._attr_value

Where _testpara_attri{} is the list with column names, and attrs{} is the list from the transpose routine.

Workspace: