Help with a sheet dividing information withing a column of cells?

So hello to all forum members, and I want to point out that while it is pretty lame of me to ask assistance of members immediately after registering for the forum, I must say in my defense that I have a time limit on a dead line and it would be insanely helpful if you could just assist me for my class in data base statistic. Every opinion will be appreciate it and I promise to provide with what little I may know on excel or related knowledge. It's for a statistic assignment and its not like I don't wanna do the work, it's just darn hard as hell, I mean this is kind of working on it since I'm posting just about everywhere for help lol.


So here it goes:
I have a sheet with a column of about 1,200 cells with series of numbers like this, five in total:
01 04 12 35 45
01 02 09 75 46
02 08 12 45 55
08 45 12 32 48
16 65 12 32 87

I need to do a couple things with this long list.
1. Is there any way to divide each pair of numbers so that each pair occupies a column of its own, giving thus each pair a column each? What I want to do then is, re-order each column in ascending order to know how many of each exact pair of numbers there are, for example:
01 08 16
01 08 16
01 08
01 08
01
So then I could clearly count six "01"'s, four "08"'s and three "16"'s that originally where in the first pairs out of the six total, originally. So now, I would only have to move on the next pair of that initially 'six' pair. So if I had twelve thousand cells in a column of six-paired numbers(eg 03 12 34 54 66) now I have five that I would need to give a column to each to know how many of each pair of numbers there were in the second series of these..(so if i had 03 12 34 54 66, and I successfully took out the first in each cell, I would now respectively have 12 34 54 66, meaning from the second and on on each cell.) Please see attached form.Book2.xlsx

2. The last piece of the puzzle would be to perform, if at any way or fashion possible, a sorting in order of each individual pair of number in their new column by the date they were populated on that database.
So again:
If,
01 04 12 35 45 3/1/14
01 02 09 75 46 3/2/14
02 08 12 45 55 3/3/14
08 45 12 32 48 3/4/14
16 65 12 32 87 3/4/14

then I want to try and divide yes, each of those numbers, into separate columns, which I will later copy paste unto a new sheet, but now, eureka, now they have dates! Hehe, So now, I could perform my other menial tasks on each sheet more closely and clearly as I would have something like:
01 3/1/14 04 3/1/14 12 3/1/14
01 3/2/14 02 3/2/14 09 3/2/14
02 3/3/14... 08 3/3/14... 12 3/3/14...

And so forth. My ideal goal would be to not only be able to divide the 1st,2nd,3rd,4th,5th pairs into a column each, but if at all possible, to do so accompanied by their populated date in a cell next to them that also allows me sort the numbers in ascending order, while keeping that original date next to them.

Thank you guys, I'll owe you so much!

Hi
it would be easier for us if you posted a sample sheet with what you have and expected results. It would avoid lots of re-typing. Thx

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($B2,"**",""),"*",REPT("*",LEN($B2))),(COLUMNS($C2:C2)-1)*LEN($B2)+1,LEN($B2)))
try this in cell "C2" and copy across

I discovered that what appeared to be spaces were in fact char(160)

Enter the following formula in C2 and copy across and down.

Formula:

Please Login or Register  to view this content.

Here is your workbook with the count of each number included.

You could select all the data, copy then in a new location Paste Values. This will give you the values without the formulae and you can sort to your heart's content.

OR

Instead of separating the values via formula, use Text to columns. Choose Fixed Width and put markers right next to the numbers leaving a space between the values. Then select each of the "spaces" and select Do Not Import. The result will be that the numbers will be separated into columns.

This is how it will turn out:

	A	B	C	D	E	F
2	*10/31/2014*	11	29	36	58	67
3	*10/28/2014*	3	50	57	58	60
4	*10/24/2014*	2	14	21	28	55
5	*10/21/2014*	5	35	37	41	66
6	*10/17/2014*	21	31	43	56	60
7	*10/14/2014*	11	37	46	64	68
8	*10/10/2014*	2	32	35	50	59
9	*10/07/2014*	16	29	46	48	55

This would be a horrendous task to do with worksheet functions. The numbers range from 1 to 75. That means that there are 5,550 two value combinations possible. 3 value combinations total 405,150. This doesn't take into consideration that most of these values occur more than 100 times each.

You need a statistician to figure this out.

I thought so lol, well, here it is so far...33.jpg @newdoverman on the statistician lol I agree, one can hope though... yeah lol... Ill hop onto a statistics forum now and come back with the results lol this is exciting! Thanks newdoverman, I knew my fellow cyber peers would be up for it! In the future who knows, what I'm trying to come up with may help more than I am looking forward to help!

33.jpg

This is a test to see if an image will upload

Just confirmed that this is a problem here.

What is the criteria for the colour assignment to the numbers?