Create output excel by transpose of one excel

M845_Buhasa_Sep’23_Timesheets.pdf_TimeSheet10.xlsx (9.1 KB)

I want to do Following

  1. Read the data from Simple Fields sheet and write it into Output Excel
  2. Read the data from EntryTimes Sheet of the same excel and split, transpose the data the write the data from J column of the output.
  3. Append the next data below the complete data…

Will u plz help with the code…

Output looks like
Output.xlsx (10.9 KB)

Hey @Omkar_Shete_CTR Provide a expected output file!

Regards,
Ajay Mishra

Given…
Output.xlsx (10.9 KB)

1 Like

Hello Ajay,
I have one input excel file and i have also share the expected output file… In the output file we need to append the data from Various input excel files… If Possible also try with VB Script…

1 Like

Hey @Omkar_Shete_CTR

Please answer below mentioned question!

All the input Excel files will be in same folder?
Sheet names will be same for each files?
Each file will only contains 1 employee detail and a timing sheet?

Regards,
Ajay Mishra

All the input Excel files will be in same folder? YES
Sheet names will be same for each files? YES
Each file will only contains 1 employee detail and a timing sheet? YES

1 Like

Hi Ajay,

If you have a solution then plz tell…

Sure! @Omkar_Shete_CTR

I was busy with some work, I’m working on your query!

Sharing your solution soon!

Regards,
Ajay Mishra

Please take your time and if possible add the solution till today night…

@Anil_G and @Vinit_Mhatre If you r working on this please/?

@Yoichi Plz tell the solution…

Hi @Omkar_Shete_CTR ,

Find Attached Workflow as per your requirement, hope it helps you
Omkar Shete.zip (18.3 KB)

Regards,
Vinit Mhatre

1 Like

Thank you so much @Vinit_Mhatre .
But there is one issue… Since our company have protected view on Excel, We have to write data once… So plz modify the code and do all the tanspose part in datatable itself at the end only write the datatable to excel… Please make the changes and send the code … That will be the most helpful for me…

I am getting output without Header

PMC services for Buhasa Portfolio (PXB) Projects Swaminathan Rajendran Instrument & Control Engineer 9 WO # 500011022 Sep-23 ADNOC-GP-500011022-KBR-MMR-013-Rev.0 UAE SITE BASED table
Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Day Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
Normal 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 PH 1
PMC services for Buhasa Portfolio (PXB) Projects Mohammad Amir Khan HSE Engineer 9 WO # 500011022 Sep-23 ADNOC-GP-500011022-KBR-MMR-015-Rey.0 UAE SITE BASED table
Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Day Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
Normal 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 PH 1
PMC services for Buhasa Portfolio (PXB) Projects Raveendra Kulkarni HSE Engineer 9 WO # 500011022 Sep-23 ADNOC-GP-500011022-KBR-M M R-014-Rev.0 UAE SITE BASED table
Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Day Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
Normal 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 PH 1
PMC services for Buhasa Portfolio (PXB) Projects Srinivas Ambadi Senior Engineer-Piping 6 WO # 500011022 Sep-23 ADNOC-GP-500011022-KBR-MMR-011-Rev.0 UAE SITE BASED table
Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Day Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
Normal 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 1 1 W 1 1 1 1 PH 1

Hey Great Work! @Vinit_Mhatre

You worked hard for the Solution! but it will be better if you just put one more post and explain each and every step how you achieved the solution.

It will be better for us to understand the logic!

I’m happy you got the solution @Omkar_Shete_CTR

Thanks,
Ajay Mishra

1 Like

Hi @Omkar_Shete_CTR ,

@Ajay_Mishra Thank you, noted will do this from next time :slight_smile:

Could you share me your current output excel file and also expected output excel file?

Regards,
Vinit Mhatre

@Vinit_Mhatre I have generated Final_ Output file
Now i want the data in Expected_Output… I want to remove date and days rows from each person and also match the header and write the output… Plz help @Vinit_Mhatre Vinit

Expected_Output1.xlsx (11.8 KB)
Final_Output.xlsx (21.6 KB)

Input File:
M845_Buhasa_Oct’23_Timesheets.pdf_TimeSheet1.xlsx (12.1 KB)

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