I misuploaded it to other forum so I moved my question to here. I am trying to program a simple code. Original data: TableA ID | Date | Type 1 20111111 A 2 20081014 C 3 20051126 A ... 100 20160421 B From this original data, I want to pick up dates by Type. Like following Result (only picking up A & B) ID | DateofA | DateofB 1 | 20111111 | 2 | | 3 | 20051126 | ... 100 | | 20160421 Are there anyone know how to program this? Thank you in advance.
... View more