How to restructure excel cell from generate data table

[koolrc812 (RC)]

Hi
I have got an excel written in the below format from generate data table activity.

my text contend is below

However I want the excel shows like below

Its a keep on going project, so will keep accumulate the data in A3, A4, A5 and so on for the value.
those phoneNo, customerId header will not need it, only wants the value thanks heaps

[Kaviyarasu_N]

Hi @koolrc812

You can use the equals (=) symbol to separate the words and add them to an array. then you can pass the value in the “generate data table actions.”

Regards,
Kaviyarasu N

[Kalimuthu_Kalimuthu (muthu)]

Hi,@koolrc812
can you below .xaml
BlankProcess7.zip (10.3 KB)
This is the output for above xaml output

cheers

[koolrc812 (RC)]

document is invalid?

[Kalimuthu_Kalimuthu (muthu)]

okk,@koolrc812
Can you try below screenshot,

Cheers!

[Kalimuthu_Kalimuthu (muthu)]

Hi,@koolrc812
above screen shot is hat working or not

Cheers!

[koolrc812 (RC)]

Hi @Kalimuthu_Kalimuthu

still trying, seems not quite to me yet. but i am still keep on trying…

the below is my flow

wonder if can add some more activities to make it work?

[koolrc812 (RC)]

Hi @Kaviyarasu_N

Im sorry you mean using equals (=) symbol to separate the words and add them to an array
means in assign activity?
any more screenshot on that? Thanks

[supermanPunch (Arpan)]

@koolrc812

my text contend is below

Hi @koolrc812 ,

Could you maybe provide this data in the form of a Text file. Also the data shown in the image consists of a single row I assume, Would there be multiple rows of data presented in the same way. Could you also give an example of that input data ?

[Kalimuthu_Kalimuthu (muthu)]

Hi,@koolrc812
i will use without generate datatable activity i make output like below

cheers!

[Kalimuthu_Kalimuthu (muthu)]

Hi,@koolrc812
Thats why can you try below logic as per the screenshot,

Cheers!

[koolrc812 (RC)]

Thanks let me try again