hello i need to turn some rows into columns for example my data looks like this I need BFC05/16/20204.436913267130131.0BFC05/16/20204.4371138 So basically all the dates stay in one column, anything within the dates get turned into columns

Rows to Columns

hello

i need to turn some rows into columns for example my data looks like this

I need

BFC	05/16/2020	4.43	69	13	26	7	130	131.0
BFC	05/16/2020	4.43	71	13	8

So basically all the dates stay in one column, anything within the dates get turned into columns

Dynamic Processing

Accepted answers

Bennel_Wilson

Hi,

I made an attempt to solve your query. Let me know if this works for you.

Input:

Output:

So,

As I did not know the maximum rows of value for each date, I had input a standard 10 columns in the Text to columns Tools.(You'll see that in the attached workflow)

Regards

Benn

P.S: In case this works for you, kindly mark it as a solution.

Text to columns.yxmd

All comments

Bennel_Wilson

Hi,

I made an attempt to solve your query. Let me know if this works for you.

Input:

Output:

So,

As I did not know the maximum rows of value for each date, I had input a standard 10 columns in the Text to columns Tools.(You'll see that in the attached workflow)

Regards

Benn

P.S: In case this works for you, kindly mark it as a solution.

Text to columns.yxmd

deviseetharaman

Hi,

Please check if this solution works for you. Alteryx Calculation.png

CrossTab.yxmd

RobertOdera

Hi, @rgarcia2

Here's how I would handle it fully automated (Columns will be auto-generated versus manually entering a parameter in Parsing Tools or manual explicit formulas in Multi-row Tool).