Getting sales volumes and quantities from a SAP-based system into an Excel sheet, I'm looking for an easy way (VBA or function) to transform those data into an Access DB.
The actual format of the data is looking like this:
Material-ID Product segment Factory Sub-group 1 Sub-group 2 Jan-12 Feb-12 Mar-12 ... Dec-12
xyz-1 PS-A F1 SG1 SG11 1213 1312 2450 1223
xyz-2 PS-B F1 SG3 SG32 2415 2543 4785 2315
After transformation, the data should look like this:
Material-ID Product segment Factory Sub-group 1 Sub-group 2 Date Sales
xyz-1 PS-A F1 SG1 SG11 Jan-12 1213
xyz-1 PS-A F1 SG1 SG11 Feb-12 1312
xyz-1 PS-A F1 SG1 SG11 Mar-12 2450
xyz-1 PS-A F1 SG1 SG11 ... ...
xyz-1 PS-A F1 SG1 SG11 Dec-12 1223
xyz-2 PS-B F1 SG3 SG32 Jan-12 2415
xyz-2 PS-B F1 SG3 SG32 Feb-12 2543
....
Thanks in advance for your good suggestions !
Bookmarks