concatenate every second row to first row

K

Kelly E.

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
 
P

Pete

Are your "header" 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, "Surname", 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.

Pete
 
K

Kelly E.

Each 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.
 
Top