Multiple Rows to Less
 

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/ =-

Multiple Rows to Less
 

Once you have removed the blank lines you could just use a pivot table to
organize your data. The pivot table would require no macro code and it would
give you pretty much everything you are asking for...
--
HTH...

Jim Thomlinson


"shhhhh" wrote:

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/ =-