combine multiple columns keeping some columns static

lramesh

New member
Joined
Oct 15, 2013
Messages
1
Reaction score
0
Points
0
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


StaffnameEmpnameEmpIDProject1DomainSubdomainProject2DomainSubdomain
AAX1WERWERDWERSPQRPQRSPQRA
BBA2VARVARDVARSEWREWRSEWRA


Target data


StaffnameEmpnameEmpIDProjectsDomainSubdomain
AAX1WERWERDWERS
AAX1PQRPQRSPQRA
BBA2VARVARDVARS
BBA2EWREWRSEWRA
 
Top