Converting a large today into only 2 columns

[Rob8489]

Hi all

Im not sure how else to explain what I'm after (hence not being able to find a solution), other than the way ive explained it in the spreadsheet attached

thank you in advance!

[:) Sixthsense :)]

Not sure really you need it or just conducting test to us lol

http://www.excelforum.com/excel-form...63#post3275863

[Rob8489]

Not sure really you need it or just conducting test to us lol

http://www.excelforum.com/excel-form...63#post3275863

oh, and its actually a different problem to the one outlined in the link you provided 6thsense.

[:) Sixthsense :)]

I have not said it is the same one

What I thought is, you are applying different permutation combinations with your data and trying to get the formula's for it....

[Rob8489]

haha, im certainly not testing anyone. And if I was i think i'd be throwing a little more difficult ones at you, but even then I dont think i'd know how to test you!!

Seriously, my spreadsheet is 200 columns x 150 rows and i dont want to be manually inserting column, copying the header in the blank column and drag down... 200 times. Hence, my asking for assistance. If you can help that would be great!!

[Rob8489]

oh, sorry, i was just stuck thats all. i hope i havent broken any rules(??). Anyway, thanks for your reply all the same

i'd be grateful if you could help me though