Hi,
I have some problem doing the conversion from column to row. I have found some very handy formula for converting column to row and vice versa, but this is not exactly what I am looking for.
My problem is this. in column A, I have product ID. In column B, I have an indicator: Y, N and W
So for example, it looks something like this
......A.......B
1 Apple....Y
2 Apple....N
3 Apple....W
4 Orange..N
5 Orange..W
What I wanted the excel to do for me is this
........A................B.........C...........D
1 Product...........Y IND...N IND......W IND
2 Apple................Y.........N............W
3 Orange..............-.........N............W
I want the program to check whether each product has Y, N or W and put it into a summary form above.
Please help. Thanks in advance
I have some problem doing the conversion from column to row. I have found some very handy formula for converting column to row and vice versa, but this is not exactly what I am looking for.
My problem is this. in column A, I have product ID. In column B, I have an indicator: Y, N and W
So for example, it looks something like this
......A.......B
1 Apple....Y
2 Apple....N
3 Apple....W
4 Orange..N
5 Orange..W
What I wanted the excel to do for me is this
........A................B.........C...........D
1 Product...........Y IND...N IND......W IND
2 Apple................Y.........N............W
3 Orange..............-.........N............W
I want the program to check whether each product has Y, N or W and put it into a summary form above.
Please help. Thanks in advance