My table is tblAllowance, has two columns.
persNumber which is the foreign key to employee table.
allowanceData which is a flat column , The data stored in this column this way: one character is for allowance code, the next 4 characters are for the allowance amount, and so on up tell 5 repeats.
I need to display the data according to allowance code
persNumber allowanceCode1 allowanceAmount 1 allowanceCode2 allowanceAmount 2 .. and so on.