Multiple Rows to Less

S

shhhhh

I am looking for helping with the following. I am getting a data dump from a program that outputs in the following format

Technician: Tech Name

Order# Description Date Start End Duration



408280 Labour 11/25/2006 15:00 19:30 4.50


411505 Contract 11/27/2006 12:15 13:35 1.33


411505 Contract 11/27/2006 13:35 14:35 1.00


406740 Project 11/27/2006 9:11 9:11 0.00


MANUAL Vacation 11/28/2006 8:30 16:00 7.50


I run a macro to remove the blank lines but what I would like is to run a single macro that could remove the blank lines and rearrange the data to look like this:

Tech Name
11/25/2006 15:00 19:30 4.50 408280
11/26/2006
11/27/2006 9:11 9:11 0.00 406740 12:15 13:35 1.33 411505 13:35 14:35 1.00 411505
11/28/2006 8:30 16:00 7.50 MANUAL

So far I am doing this manually but it consumes a fair amount of time as there are multiple techs, each of them is separated by two rows:
Total
Order #

Would anybody be able to help automate this process?

Thanks in advance for any assistance.





--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top