Forum Discussion
Solved
Transform data
Hello everyone
Can anyone help me transform data from table one (blue) to table 2 (green).
is there any formula I can use so I don't have to insert data manually?
Thank you in advance for your help
OK, I see what you want now. New version attached.
6 Replies
See the attached demo. (I think your example contains some mistakes, if I understood your intention correctly)
- thank you for your fast response I already saw your demo. but I didn't make any mistakes in my example table. in another hand when I saw your demo the first and second row is correct but the rest does not match my example. table green is the result I wanted from the source data table blue. by the way, thank you again for trying to help.
*I want to try to explain further but I really bad at EnglishCan you explain why the lower left cell in the second table should be 6 while the lower left cell in the first table contains C?
