Creating dimension from data on a single row

[nsm1234567]

Hi There,

I'm hoping someone might be able to assist with some trouble I'm having sorting out some oddly formatted data.  Below I've approximated what my data looks like (except that there are many more themes).  What I want ultimately is a new dimension called "Theme" which would consist of "Service" and "Brand" in the below case.  There would then be two instances of the "Service" theme (one negative and one positive) and another instance of the brand theme.  I've pasted my envisaged table under "Targeted" below.  Does anyone know how I might be able to accomplish that?   Any help would be greatly appreciated.

Current:

ID	Positive Theme 1	Positive Theme 2	Negative Theme 1	Negative Theme 2
1	Positive Service
2		Positive Brand	Negative Service

Targeted Table:

ID	Theme
1	Service
2	Service
2	Brand

[avinashelite · Accepted solution]

Hi  Nathan,

Please find the attachment for the solution:

[avinashelite]

I have designed the above solution based on your question inputs , actually what is the exact requirement??

so that we can guide you on the proper path to achieve your requirement

[nsm1234567]

Hey There, that is perfect for my needs.  Thanks so much