Hello,
I need help with code stage to transpose the collection as seen in the screenshots. I need to take columns from E to N and it's values and transpose them as columns for each row. The values for columns A to D should copy down to the last row for each date (as seen in row 8 to 38) Is this something do-able in Blue Prism? I tried this using Macro but its too slow. So now thinking to import this data from excel into Blue Prism and then use collection manipulation with code.
Thank you
TO:
I need help with code stage to transpose the collection as seen in the screenshots. I need to take columns from E to N and it's values and transpose them as columns for each row. The values for columns A to D should copy down to the last row for each date (as seen in row 8 to 38) Is this something do-able in Blue Prism? I tried this using Macro but its too slow. So now thinking to import this data from excel into Blue Prism and then use collection manipulation with code.
Thank you
TO: