This is a sample of the data I have
I would like to have my data like this - Image titled target file
Please let me know how this can be done with or without macros.
Source data
Staffname Empname EmpID Project1 Domain Subdomain Project2 Domain Subdomain A AX 1 WER WERD WERS PQR PQRS PQRA B BA 2 VAR VARD VARS EWR EWRS EWRA
Target data
Staffname Empname EmpID Projects Domain Subdomain A AX 1 WER WERD WERS A AX 1 PQR PQRS PQRA B BA 2 VAR VARD VARS B BA 2 EWR EWRS EWRA
Excel 2010, Tables
De-Normalize Database
A generic example.
To adapt macro to your application and to be able to maintain it,
a high level of VBA expertise is required.
http://www.mediafire.com/download/au.../10_13_13.xlsm
Bookmarks