software

I have to prepare a report using data from access which is in the following
format:-

Surname First_nameDesc Amt
TRANCOSO MONIQUEBasic Salary $4,631.00
TRANCOSO MONIQUELIVING OUT $100.00
TRANCOSO MONIQUELAUNDRY $110.32
TRANCOSO MONIQUEINCENTIVE $1,157.75
TRANCOSO MONIQUECOLA $60.00
TRANCOSO MONIQUEMEAL $304.84Into the following format:-

Surname First_name Basic Salary AllowancesAmt
TRANCOSO MONIQUE $4,631.00 LIVING OUT$100.00
LAUNDRY$110.32
INCENTIVE$1,157.75
COLA$60.00
MEAL$304.84

Can anyone help?


Use the concatenate function after trimming out unwanted text in 2nd to
5th rows using MID function.--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=534929