I've a pretty challenging work to do, I am trying to use di ACCESS SQL to transpose rows/columns, till now, with no luck.
've tried the TRANSFORM instruction but the reuired columns to output are not fixed, so this approach doesn't get the point...
Please, see the attached file for an example.
Click to view attachment
Any suggestion wll be very very well accepted