combine multiple columns keeping some columns static

lramesh · Oct 15, 2013

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 · Oct 16, 2013

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/au9xvht2fdy96l6/10_13_13.xlsm

combine multiple columns keeping some columns static

lramesh

New member

Herbds7

Banned