Excel data formation help want

Help Studio
, ,
1

image
image385×517 7.62 KB

I have this data extracted from PDF in excel… Now i want to separate each data.
like in date column i want 1 to 31 serially
in Day column also same serially
in Normal column also same logic…

How to do that?

2

@Omkar_Shete_CTR

Follow the steps

  1. First merge the same datatble and create same rows ar the bottom…merge datatble with dt and dt
  2. Use for each row in datatable and assign a index variable to index property in properties
  3. Inside the loop use if condition with index <= dt.Rowcount/2
  4. On then side use currentrow(0) = currentrow(0).Tostring.Split(" "c).First similarly use with 1 and 2
  5. On the else side use currentrow(0) = currentrow(0).Tostring.Split(" "c).Last similarly use with 1 and 2
  6. Delete the extra row if the number of rows are 32 else dont delete…extra row would be dt.rowcount/2-1

Cheers

3

Test11.xlsx (8.5 KB)
Will u plz help me with the workflow…

4

image
image262×818 8.24 KB

i AM NOT ABLE TO WRITE .LAST

5

Hi @Omkar_Shete_CTR

Kindly find below attached flow as per your requirement
Main.xaml (27.4 KB)

Hope it works for you

Regards,
Vinit Mhatre

6

Thank you @Vinit_Mhatre for your Valuable efforts…

1 Like
7

Anytime :slight_smile:

Happy Automation !!!

Regards,
Vinit Mhatre

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.