I have 159740 lines of data that look simular to this below, item number the next line or several lines locations numbers.
I am think possibly some kind of a loop but looking for a starting direction. to put the data into a table file to work with. Any thoughts how to do this??
Thanks
Sheet1
<COLGROUP> <COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 354px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"> </COLGROUP><TBODY>
</TBODY>
Excel tables to the web >> Excel Jeanie HTML 4
I am think possibly some kind of a loop but looking for a starting direction. to put the data into a table file to work with. Any thoughts how to do this??
Thanks
Sheet1
A | B | C | D | |
1 | Total For Unit of Measure: | 83 | 83 | |
2 | XH3G 3" DUAL TITE GASKETS XH (75PK 342 | |||
3 | 100 100 521 502 4 700 14 1 00004519329 | EA | 63 | 63 |
4 | Total For Unit of Measure: | 63 | 63 | |
5 | XH4G 4" DUAL TITE GASKETS XH (60PK 343 | |||
6 | 100 100 500 503 2 4 3 1 00004236988 | EA | 65 | 65 |
7 | Total For Unit of Measure: | 65 | 65 | |
8 | XH5G 5" DUAL TITE GASKETS XH (30PKQ 344 | |||
9 | 100 100 621 602 10 600 13 1 00004598010 | EA | 43 | 43 |
10 | Total For Unit of Measure: | 43 | 43 | |
11 | XH8G 8" DUAL TITE GASKETS XH (20PK 346 | |||
12 | 100 100 500 503 12 1 4 1 00003603261 | EA | 20 | 20 |
13 | 100 100 500 503 12 1 4 1 00003603261 | EA | 10 | 10 |
14 |
<COLGROUP> <COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 354px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"> </COLGROUP><TBODY>
</TBODY>
Excel tables to the web >> Excel Jeanie HTML 4