Rearranging Data in Excel

K

Keensie

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

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


Into the following format:-

Surname First_name Basic Salary Allowances Amt
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?
 
R

robert111

Use the concatenate function after trimming out unwanted text in 2nd t
5th rows using MID function
 
Top