| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate every second row to first row
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number formats after concatenate | Excel Worksheet Functions | |||
| number formats after concatenate | Excel Worksheet Functions | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Threaded Mode
