How to convert unstructured text data to excel

[Durgarao_Undi]

Hi,
I want to convert text to excel as per my attachments.
input-----string

Date

PLATFORM

SENDER

Q.TY (M3)

RECEIVER

Q.TY (M3)

27/10/2022

UiPath

MOON

14678

Normal

2,3

8846

MSK

Polo

4,30

output-----excel

Thanks

[Irene]

The columns in your screenshot don’t seem to match the input data. Can you confirm that the expectation is that the same text of the input will be used for the output (with no additional manipulations)?

[Durgarao_Undi]

For Sender we have 3 values in that column that’s why i mentioned that in output as sender brand,shopname like that .For receiver also same thing

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

CC :: @Gokul001 @Anil_G @ppr @Nithinkrishna @THIRU_NANI @jack.chan @Palaniyappan

[THIRU_NANI (NaNi)]

Hey, welcome to community,

Use generate data table activity and use the separator as new line.

Regards,
NaNi

[pratik.pandya]

@Durgarao_Undi

Use “Generate Data Table” Activity and pass the string variable into it. Also, use New Line Seprator for seprating string.

Hope this works!!

[Irene]

@THIRU_NANI @pratik.pandya I don’t think these suggestions will work with the input he provided.
He has just a list of strings. There are no column separators, just one word per line, so there’s no way to know how many columns are expected and which lines are headers and which are values in the rows.