Transpose data into one row

[JokeFun]

I have a list of data in below sample format:

Customer No	Corp Type	YesNo
12345	c.a	Y
	c.b	Y
	c.c	Y
	c.d	Y
	c.e	Y

What I want to show is like this: 

Customer No	c.a	c.b	c.c	c.d	c.e
12345	Y	Y	Y	Y	Y

What I have now after using transpose tool is like below. Appreciate your help!

Customer No	c.a	c.b	c.c	c.d	c.e
12345	Y
12345		Y
12345			Y
12345				Y
12345					Y

[Tony_Castillo · Accepted solution]

Instead of Transpose, why not use Crosstab? 

I added a formula presuming you will have multiple customer numbers in your dataset with blank rows:

if IsEmpty([Customer No])then [Row-1:Customer No] else [Customer No] endif

Spoiler