excel help (in Off-topic)

QBPit Spawn [Abyssal Specters] December 1 2006 5:01 PM EST

im trying to turn this:
1 # #
1 # #
1 # #
2 # #
2 # #
2 # #
into this:
1 # # 1 # # 1 # #
2 # # 2 # # 2 # #

QBJohn Birk [Black Cheetah Bazaar] December 1 2006 5:11 PM EST

Try this Pit:

copy 1 # #
1 # #
1 # #

Then highlight an entire row by clicking the row number.

Then choose paste. You MIGHT have to choose paste special, but I think that will do what you want.

Then of course repeat for the "2" values.

QBPit Spawn [Abyssal Specters] December 1 2006 5:12 PM EST

the problem with that is that my data file is 15000 lines long

bartjan December 1 2006 5:25 PM EST

Does it really have to be in Excel? If you can send me it in Comma Separated Values (CSV) format, I'll run it through some really powerful tools (like awk).

QBPit Spawn [Abyssal Specters] December 1 2006 6:09 PM EST

i got it working, wrote a program in python :). thnx for the help everyone

This thread is closed to new posts. However, you are welcome to reference it from a new thread; link this with the html <a href="/bboard/q-and-a-fetch-msg.tcl?msg_id=001xzJ">excel help</a>