How to Clean Unstructured Data Table

Help Studio
, , , ,
1

hello all,

I have an excel sheet which is unstructured .
UnstructureData.xlsx (40.8 KB)
please check the UnstructureData.xlsx
Now my requirement is to structure the data table . The data table should be like this
StructureData.xlsx (25.4 KB)
I have to make the UnstructureData.xlsx to StrctureData.xlsx .

Would you please suggest me how would I clean the excel file and make that like StructureData.xlsx

Thanks in Advance

2

@roysupriya21
I build datatable(structured) then add data row from unstructured.
Forum0611.zip (35.8 KB)

image
image373×674 14.5 KB

3

hey thanks for your reply . would you kindly check why the date column value showing like “44228”
date
Thanks in Advance

4

@roysupriya21
Because of Cell Format.

image

When I change format to Date, I can see the correct content.

image
image823×547 21.1 KB