Solved: Reorgranize data

[username123]

I have a worksheet with data looking as follows:

Serial# result1 result2 ... resultn
A
A
A
B
B
B
C
C
C
.
.
.
X
X
X

i want to make these into tables

result1
serial# trial1 trial2 trial3
A
B
C
.
.
.


result2
serial# trial1 trial2 trial3
A
B
C
.
.
.


any ideas on how to do this.

[MaximS]

check attachment for details i hope that will do the job.

[username123]

THANKS MaximS!!!

I think this is awesome...it should do the trick.

I really appreciate the help!

[username123]

Hey MaximS

your unique function is great!

how would i modify that fuction to return the number of each serial number occuring (i.e. 3 for the example in the original post)?


thanks!

[MaximS]

Try this:

[VBA]Cells(1,1).Value = UBound(Category)[/VBA]


this should fill "A1" with nuber of unique serial numbers

[username123]

No, I mean if I want to store the occurrences of each serial number in an array..so the array is like this:


Serial1, 5
Serial2, 3
Serial3, 2
Serial4, 3
Serial5, 3
.
.
.


basically, i want to make the program more usable...so as opposed to each serial number occurring 3 times...if some occur 2 others 4 it will list the trials according to the largest number of occurrences, leaving trial4, etc.. blank if that particular serial number does not have that many trials, i.e:

result1
serial# trial1 trial2 trial3 trial4 trial5
A data data data
B data data data data data
C data data
.
.
.


result2
serial# trial1 trial2 trial3 trial4 trial5
A data data data
B data data data data data
C data data
.
.
.


Do you understand what I am saying

I really appreciate the help...let me know if you need ANYTHING!

[MaximS]

I will look in to this.

[username123]

Thanks...you are seriously the best!

[MaximS]

try now this will work no matter how many trials per item (ie A or B) you have.

[username123]

I will try this out and let you know how it goes. THANK YOU!

[username123]

works fine...thats for all the help.

i really appreciate it