Hi Everyone,
I am trying to transpose the input datatable and add a new “Date” column. I would like to run this script everyday once and append data after each run. Kindly request you to help me with this
My input data table is of the below format
C1 1 2 3
C2 4 5 6
C3 7 8 9
C4 10 11 12
Expected Output
Date C1 C2 C3 C4
Day1 of Robot run date 1 4 7 10
Day1 of Robot run date 2 5 8 11
Day1 of Robot run date 3 6 9 12
Day2 of Robot run date 1 4 7 10
Day2 of Robot run date 2 5 8 11
Day2 of Robot run date 3 6 9 12