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
Solved! Go to 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.
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!
Thanks mate, this worked flawlessly
Glad, I could help. It was a nice piece of learning for me as well.
Hi @RobertOdera ,
Liked this approach as well. Thanks for sharing.
Sure @Bennel_Wilson
My pleasure!
Simple and highly effective!