Spilt formula

Question

Hello,

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

Input-

SourceVolumesDevika250Devika950Devika1000Devika3000Vineeth350Vineeth150Vineeth2500Vineeth4000Vineeth5500

Output expected -

SourceVolumesDevika Vineeth Devika250250 Devika950950 Devika10001000 Devika30003000 Vineeth 350 350Vineeth 150 150Vineeth 2500 2500Vineeth 4000 4000Vineeth 5500 5500

AngelosPachis · Accepted Answer

Hi @Devika

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

atcodedog05 · Accepted Answer

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 Answer

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

Thanks.