Combine Columns into Single Column (+Transform?)

[#1]

Hello!

I'm stuck with what I think is a concatenate and a replace  - but I was hoping there might be a useful/simple/better way of doing it.

I have four columns of data I want to turn into one column of data, as below:

Easy way to do it?

Alex

[maxgro]

tt:

load * inline [

ID, Labour,Conservative,Green,UKIP

1,Yes,,,

2,,Yes,,

3,,,Yes,

4,,,,Yes

];

ct:

CrossTable (Party, YesNo)

LOAD * Resident tt

;

final:

NoConcatenate load ID, Party Resident ct where len(trim(YesNo))>0;

DROP Table ct, tt;