I have a certain dataset all in the same table, and I want to split it into a relational database in MS Access. I've been successfull to a certain degree but now I have a problem.
My dataset had the products available in a certain store displayed like this:
ButIwantitinawaythatfollowsthisrelationalmodel:
-
SofarImanagedtosplittheproductsinExcel,soeachproductisinadifferentcolumn,likethis:
But I have no idea what the next step is ..
Thanks in advance