i have a code like this
P 1095 SMITH, HOWARD
C 01-08-11 $45.0
C 01-17-11 $37.5
P 1096 BARCLAY, NICK
C 01-09-11 $150.5
P 1097 REISCH, DEBORAH
C 01-02-11 $109.0
C 03-02-11 $100.0
P 1099 WILSON, ERNEST
C 01-03-11 $45.0
C 01-05-11 $45.0
and i need it to convert it to like this
Obs name id date sales
1 SMITH, HOWARD 1095 01/08/11 $45.00
2 SMITH, HOWARD 1095 01/17/11 $37.50
3 BARCLAY, NICK 1096 01/09/11 $150.50
4 REISCH, DEBORAH 1097 01/02/11 $109.00
5 REISCH, DEBORAH 1097 03/02/11 $100.00
6 WILSON, ERNEST 1099 01/03/11 $45.00
7 WILSON, ERNEST 1099 01/05/11 $45.00
how to get the result. Any leads?