I hope someone can help.
I have the following table in excel:
I would like to extract the new data into a new table based on date and New Value:
ID Centre Language
I have no idea even where to begin.
Thanks in advance.
I have the following table in excel:
1 | ID | CREATED DATE | FIELD | NEW VALUE | OLD VALUE |
2 | 001 | 2020/01/15 | Language | German | French |
3 | 001 | 2020/01/15 | Latest Outlet | a001 | a002 |
4 | 001 | 2020/01/15 | Latest Outlet | Parndorf | Provence |
5 | 002 | 2020/01/16 | Language | French | English |
6 | 002 | 2020/01/16 | Latest Outlet | a002 | a003 |
7 | 002 | 2020/01/16 | Latest Outlet | Provence | Ashford |
ID Centre Language
001 | Parndorf | German |
002 | Provence | French |
Thanks in advance.