software

I have a dataset that contains an array of data values. The first row
contains the header information (A1:W1) for the data and the second row
contains the data (A2:IU2). This combination is repeated over 2400 times in
one file. I would like to add the second line of data to the first line of
attributes and repeat over the length of the file (down to row 4822), so that
I can then import the data into a GIS. Anyone have any suggestions on how
best to do this?
Thanks!
Kelly

Are your quot;headerquot; rows in A3:W3 and A5:W5 etc the same as those in
A1:W1? If so, then you can apply autofilters and if one of the header
descriptions is, for example, quot;Surnamequot;, you can filter for this on
that column. Highlight all the rows that are displayed (except the top
one) and Edit | Delete Row. When the filter is taken off all your
duplicated header rows will have been deleted.

Hope this helps.

PeteEach header row is different and contains a unique location and time, which
needs to be concatenated with the data row directly below it in order to
convert to a shapefile.

quot;Petequot; wrote:

gt; Are your quot;headerquot; rows in A3:W3 and A5:W5 etc the same as those in
gt; A1:W1? If so, then you can apply autofilters and if one of the header
gt; descriptions is, for example, quot;Surnamequot;, you can filter for this on
gt; that column. Highlight all the rows that are displayed (except the top
gt; one) and Edit | Delete Row. When the filter is taken off all your
gt; duplicated header rows will have been deleted.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;