ripkin900
01-08-2012, 06:52 AM
Hi, I have a text file...
When I import it into Excel the one column data fills 2 rows.....
SO I am looking for a Macro to take cells H1, H2 combine them into a new column, and put them in cell J1
So then h3, h4 will go into J3
It is a paginated text file, so every 20 rows there is the headers which can be ignored....
So I think a do while would work but I cannot figure it out, any help would be greatly aprecciated
Sample text file:
Dept: IL_DF_INSP IL DF 1ST PIECE INSPECTION
|---------------Scheduled---------------|
Operation Start Operation Compl Job Compl Build |----Operation----| |-----------Quantity-----------|
Date Time Date Time Date Job Assembly Seq Seq Description Remaining In Queue Running
--------------- --------------- --------- --------------- --------------- ----- ---- -------------- ---------- ---------- ----------
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711085 675.181230.3012 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711086 675.181230.3022 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711088 675.181230.3032 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711089 675.181230.3042 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711090 675.181230.3052 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711094 675.181230.3082 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711095 675.181230.3092 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711096 675.181230.3102 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711097 675.181230.3112 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711098 675.181230.3122 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:54 16-MAR-12 06:59 19-MAR-12 6711091 675.181230.3062 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:54 16-MAR-12 06:59 19-MAR-12 6711093 675.181230.3072 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709534 675.115499.3012 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
XXXXXXXXXXXXX USA Report Date: 07-JAN-2012 06:09
Sort By Operation start date Discrete Job Dispatch Report Page: 413 of 4957
Include Unreleased Jobs: Yes
Dates From 01-JAN-06 To 30-JUN-12
Dept: IL_DF_INSP IL DF 1ST PIECE INSPECTION
|---------------Scheduled---------------|
Operation Start Operation Compl Job Compl Build |----Operation----| |-----------Quantity-----------|
Date Time Date Time Date Job Assembly Seq Seq Description Remaining In Queue Running
--------------- --------------- --------- --------------- --------------- ----- ---- -------------- ---------- ---------- ----------
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709535 675.115499.3022 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709541 675.115499.3082 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709542 675.115499.3092 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:46 19-MAR-12 04:48 21-MAR-12 6709536 675.115499.3033 40 1ST PIECE 14.00 0.00 0.00
When I import it into Excel the one column data fills 2 rows.....
SO I am looking for a Macro to take cells H1, H2 combine them into a new column, and put them in cell J1
So then h3, h4 will go into J3
It is a paginated text file, so every 20 rows there is the headers which can be ignored....
So I think a do while would work but I cannot figure it out, any help would be greatly aprecciated
Sample text file:
Dept: IL_DF_INSP IL DF 1ST PIECE INSPECTION
|---------------Scheduled---------------|
Operation Start Operation Compl Job Compl Build |----Operation----| |-----------Quantity-----------|
Date Time Date Time Date Job Assembly Seq Seq Description Remaining In Queue Running
--------------- --------------- --------- --------------- --------------- ----- ---- -------------- ---------- ---------- ----------
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711085 675.181230.3012 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711086 675.181230.3022 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711088 675.181230.3032 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711089 675.181230.3042 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711090 675.181230.3052 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711094 675.181230.3082 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711095 675.181230.3092 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711096 675.181230.3102 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711097 675.181230.3112 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:20 16-MAR-12 06:25 19-MAR-12 6711098 675.181230.3122 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:54 16-MAR-12 06:59 19-MAR-12 6711091 675.181230.3062 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
16-MAR-12 02:54 16-MAR-12 06:59 19-MAR-12 6711093 675.181230.3072 40 1ST PIECE 60.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709534 675.115499.3012 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
XXXXXXXXXXXXX USA Report Date: 07-JAN-2012 06:09
Sort By Operation start date Discrete Job Dispatch Report Page: 413 of 4957
Include Unreleased Jobs: Yes
Dates From 01-JAN-06 To 30-JUN-12
Dept: IL_DF_INSP IL DF 1ST PIECE INSPECTION
|---------------Scheduled---------------|
Operation Start Operation Compl Job Compl Build |----Operation----| |-----------Quantity-----------|
Date Time Date Time Date Job Assembly Seq Seq Description Remaining In Queue Running
--------------- --------------- --------- --------------- --------------- ----- ---- -------------- ---------- ---------- ----------
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709535 675.115499.3022 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709541 675.115499.3082 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:34 19-MAR-12 04:36 21-MAR-12 6709542 675.115499.3092 40 1ST PIECE 14.00 0.00 0.00
INSPECTION -
IL
18-MAR-12 00:46 19-MAR-12 04:48 21-MAR-12 6709536 675.115499.3033 40 1ST PIECE 14.00 0.00 0.00