Let me rephrase this,
My Code:
To avoid coping all my code again print SpaceTree gives us (A:B:C:A:C:D) for each line of data.
SkyTree = [SpaceTree.split(':') for x in SpaceTree]
Gives me this:
[[u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D'], [u'A', u'B', u'C', u'A', u'C', u'D']]
Now I need to take that hot mess and turn it into
[[A:B:C:D], [A:B:C:D], [A:B:C:D], [A:B:C:D], [A:B:C:D], [A:B:C:D]]
... so that I can put it into a spreadsheet like this
Spreadsheet 1 Spreadsheet 2 Master Final Sheet
Trees Location Birds Trees Location Birds Trees Location Birds
1A A,B A:B:C 1A A,B A:D:C 1A A,B A:B:C:D
2B A,B C:A:B 2B A,B A:B:D 2B A,B A:B:C:D
3C A,B C:B:A 3C A,B D:B:C 3C A,B A:B:C:D
BUT this will be used on tens of thousands of lines of data. It will also have certain feilds like Tree height, Bird Color, ect.