Mrs Chrismo says it can't be done. I'm hoping someone else knows how. If it were me, I'd just sort the main data, then cnp the 2nd and 3rd rows of each section, since they're all the same anyway. On Tue, May 8, 2012 at 8:12 PM, Patrick Wiggins <paw@wirelessbeehive.com>wrote:
Here's the way the file is produced:
http://users.wirelessbeehive.com/~paw/temp/excelchallenge.zip
Looks like it's going to be a long night of data-taking tonight (yea!) so I'll have lots of time to try out the various suggestions that have been made here today.
Thanks all!
patrick
On 08 May 2012, at 15:43, Patrick wrote:
Hi,
The original is a text file.
I'm converting it to Excel so I can use Excel's sort function since I don't think text files can be sorted.
I'll post a complete original file when I get home this evening for folks to play with.
Thanks to all for their help.
patrick
On 08 May 2012, at 14:12 , Chrismo wrote:
i guess i'm not understanding how the original data is formatted. is this stuff: SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
not in a spreadsheet to start off with?
_______________________________________________ Utah-Astronomy mailing list http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
Send messages to the list to Utah-Astronomy@mailman.xmission.com
The Utah-Astronomy mailing list is not affiliated with any astronomy club.
To unsubscribe go to: http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Then enter your email address in the space provided and click on "Unsubscribe or edit options".
-- Chrismo I fix things, all kinds of things... (801) 897-9075