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 

Can you provide a sample of input data in an excel file.

Method should be transpose and crosstab

[Genty]

See attached, this is a cut down version of sample data but the format in which it is pulled

[atcodedog05 · Accepted solution]

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 : )

[atcodedog05]

Hi @Genty 

We can rename total1, total2 as "total ", "total  " where number is replaced with number of spaces.

Workflow:

It maintains distinct names and also gives a look-alike feel.

Hope this helps : )

[Genty]

thanks for this.

[sgwong]

Need advice on how to convert rows to multiple columns as per attached