Spilt formula

[Devika]

Hello,

Request you to help me to split the data as per below 

Input-

Source	Volumes
Devika	250
Devika	950
Devika	1000
Devika	3000
Vineeth	350
Vineeth	150
Vineeth	2500
Vineeth	4000
Vineeth	5500

Output expected -

Source	Volumes	Devika	Vineeth
Devika	250	250
Devika	950	950
Devika	1000	1000
Devika	3000	3000
Vineeth	350		350
Vineeth	150		150
Vineeth	2500		2500
Vineeth	4000		4000
Vineeth	5500		5500

[AngelosPachis · Accepted solution]

Hi @Devika 

Have a look at the attached workflow, I think it gives you what you are looking for

[atcodedog05 · Accepted solution]

Hi @Devika 

Here is a workflow for the task

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[grazitti_sapna · Accepted solution]

Hi @Devika , you can do this using cross tab tool, here is the configuration.

Thanks.

[atcodedog05]

Happy to help 🙂 @Devika 

Cheers and happy analyzing 😀