Hi,
So, I am working on a dataset to create some reconciliations and was transforming it so that they both are in same orientation and layout and stuck at 1 point.
My data looks like something like this: (IDs are the unique identifiers though it is repeated here as this data has been created after some transpose operations. Owner in 1 ID will remain same)
ID Moderator % 1 % 2 % 3 Name Owner Name
1 A 100 0 0 Owner Name 1 snjk ghj
2 B 50 50 0 Owner Name 1 asa hjhgs
2 B 50 50 0 Owner Name 2 sa hjkjhs
3 C 25 35 40 Owner Name 1 asas hkjjh
3 C 25 35 40 Owner Name 2 sasas
3 C 25 35 40 Owner Name 3 jhkjahsa
4 D 77 23 0 Owner Name 1 asasasasa
4 D 77 23 0 Owner Name 2 qjkwqjwh
5 E 100 0 0 Owner Name 1 poioioioio
Basically 1 ID can have upto 3 rows and minimum 1 row, based upon whether it has 1 owner or 2 owners or 3 owners, and % 1,2,3 tell how much ownerhsip % that particular owner has and thus, sum will be 100%.
I need 1 row item for 1 owner type and it's corresponding % in a column called "%". Like owner name columnn has come, 1 owner in 1 row, but need it's corresponding % in % column. So that later i can unselect all separate columns %1,2,3.
Would look something like this:
ID Moderator % 1 % 2 % 3 Name Owner Name %
1 A 100 0 0 Owner Name 1 snjk ghj 100
2 B 50 50 0 Owner Name 1 asa hjhgs 50
2 B 50 50 0 Owner Name 2 sa hjkjhs 50
3 C 25 35 40 Owner Name 1 asas hkjjh 25
3 C 25 35 40 Owner Name 2 sasas 35
3 C 25 35 40 Owner Name 3 jhkjahsa 40
4 D 77 23 0 Owner Name 1 asasasasa 77
4 D 77 23 0 Owner Name 2 qjkwqjwh 23
5 E 100 0 0 Owner Name 1 poioioioio 100
Then, % 1, % 2, % 3 columns will be unselected. The other file which is to be reconciled with this has the exact same format.
