Combining Data by Number Identifier

[huntertussey]

Hello, 

I'm trying to combine data for customers but have been unable to find a way to do so. I have unioned data from different months and want to combine the monthly data for each customer. In Table 1 is example of what data looks like coming in, and Table 2 is what the end result should look like.

Table 1

Customer Number	June	July	August
123	Y	Null	Null
456	N	Null	Null
123	Null	Y	Null
456	Null	Y	Null
123	Null	Null	Y
456	Null	Null	N

Table 2

Customer Number	June	July	August
123	Y	Y	Y
456	N	Y	N

Any help is appreciated, thanks!

[alexnajm · Accepted solution]

Transpose the data (group on Customer Number and select the rest as data fields), Filter out the null values, and Crosstab back (group by customer Number, header is Name and value is Value, concat or first should work to aggregate)!

[huntertussey]

Thank you, worked perfectly!