combine multiple columns keeping some columns static

[lramesh]

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

[Herbds7]

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