ExcelBanter - Rearranging Data in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rearranging Data in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/84420-rearranging-data-excel.html)

Rearranging Data in Excel

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?

Rearranging Data in Excel

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

--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=534929