HI,

I have a similar data type as below

name p/n data to sent y/n response received y/n meet
requirements y/n
john a y y
john b
john c y
john d y y
y
john e n

When I create a pivot table I need the following:

name data sent y data sent n blanks
john 3 1 1

Please advise on how to create.
Thanks