I have a daily download file of excel with just 16 rows. However i need to copy / paste selected rows with values to another column to sum up row level totals to column totals.
In my excel i have entities in Col A, Currency in Col B and Daily values in Col C.
I have to copy list of all entities (no duplicates) in a new col E
Copy values from row C2 to C4 to new Col F and
Copy values from row C6 to C9 to new Col G
While the values are copied to new columns, they need to be divided by 1000000
here’s a pic -
Appreciate your kind help please.