I managed to figure it out. Turns out Excel has a nice little function called CONCATENATE and then all I had to do was write a macro to delete every 2nd line.
--------------------------- Brian Weeden Technical Advisor Secure World Foundation <http://www.secureworldfoundation.org> +1 (514) 466-2756 Canada +1 (202) 683-8534 US On Mon, Aug 23, 2010 at 3:04 PM, Anthony Q. Martin <[email protected]>wrote: > Have you thought about using a text editor that can record and playback > keystrokes repeatedly? That way, you can do the manipulation before loading > into the Excel. UltraEdit might be the one to try. Use a copy of your data > file to tell if it works. > > > On 8/23/2010 11:43 AM, Brian Weeden wrote: > >> Got a problem that I need some quick advice on. >> >> I have a large amount of text data that I need to analyze in Excel. The >> problem is converting the data from its native text format into separate >> rows/columns in a spreadsheet. I can use the file import option to bring >> it into excel, but once it's in I need to concatenate every 2nd row to the >> end of the row above it. So if after import I have the following: >> >> A B C D E F G >> H I J K L M N >> A2 B2 C2 D2 E2 F2 G2 >> H2 I2 J2 K2 L2 M2 N2 >> >> I need to end up with the following: >> >> A B C D E F G H I J K L M N >> >> A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2 N2 >> >> It's easy to do by hand, but with over 2,000 data sets it would be >> tedious. Thoughts? >> >> --------------------------- >> Brian Weeden >> Technical Advisor >> Secure World Foundation<http://www.secureworldfoundation.org> >> >> +1 (514) 466-2756 Canada >> +1 (202) 683-8534 US >> >> >> >> No virus found in this incoming message. >> Checked by AVG - www.avg.com >> Version: 9.0.851 / Virus Database: 271.1.1/3089 - Release Date: 08/23/10 >> 02:35:00 >> >>
