Morning all,
I'm trying to synch some new data into some old data and am wondering if there is a better way of doing this than my method which is held together by sheer good will (&frustration!)
Our Old Data is laid out like this:
Our Updated Data looks like this:
(Sometimes the data needs to be added in, but sometimes it's already on there).
All in all, the results should hopefully look something like this... wonder if somebody could help??
Huge thanks!
I'm trying to synch some new data into some old data and am wondering if there is a better way of doing this than my method which is held together by sheer good will (&frustration!)
Our Old Data is laid out like this:
LineID | Colour1 | Condition1 | Colour2 | Condition3 | Colour3 | Condition3 |
2 | brown | good | ||||
3 | red | average | orange | awful | ||
4 | brown | black | excellent | |||
5 | brown and red |
(Sometimes the data needs to be added in, but sometimes it's already on there).
Line ID | Colour | Condition | notes (wouln't be on the actual data, just to help explain here...!) |
3 | orange | awful | Orange is already on Line ID 3, no need to add |
3 | white | excellent | Colour & condition would need to be added to Line ID 3 |
4 | brown | awful | Although colour is already on Line ID 4, the "awful" would need to be added |
4 | white | White would need to be added in to Colour 3 on line ID 4 | |
5 | brown | excellent | Add the new updated colour and condition to Line ID 5 |
Huge thanks!
Line ID | Colour1 | Condition1 | Colour2 | Condition2 | Colour3 | Condition3 | Colour4 | Condition4 |
2 | brown | good | ||||||
3 | red | average | orange | awful | white | excellent | ||
4 | brown | awful | black | excellent | white | |||
5 | brown and red | brown | excellent |
Last edited: