Rows to Columns

[rgarcia2]

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 

[Bennel_Wilson · Accepted solution]

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.

[deviseetharaman]

Hi,

Please check if this solution works for you.

[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).

Please mark as an acceptable solution and LIKE, if this works for you.

Solution Output

Workflow

Please see the attached flow.

Good Luck!

[rgarcia2]

Thanks mate, this worked flawlessly

[Bennel_Wilson]

Glad, I could help. It was a nice piece of learning for me as well.

[Bennel_Wilson]

Hi @RobertOdera ,

Liked this approach as well. Thanks for sharing.

[RobertOdera]

Sure @Bennel_Wilson 

My pleasure!

[brwright]

Simple and highly effective!