Transpose Row into multiple columns

Genty

Hi all,

I am having to create a workflow to take rows from a excel document and push them into server.

because they are from rows alteryx sees them like the below.

I need to get them to columns like the below (but with all data):

PureOnline HD	Total	Total	Total	Total	Total
2021-05-02	1215.272	7.766788	7119.449	5544.247	73.46532

from there I can rename the headers and push it into a table.

atcodedog05

Hi @Genty 

Here is how you can do it. I have used sample of data.

Workflow:

1. Since there are multiple total i am using record id to set a distinct

2. Using formula tool to create new total name as total1, total2

3. Using transpose to convert date columns to rows with PureonlineHD, RecordID and New column as keys

4. Using crosstab to convert to table with Name as key, New name as name and value as value.

Hope this helps : )

Dates.yxmd