lists for conditional probability

[Jordan411]

Hey guys probably an easy question for most of you but im still new .

I have a spreadsheet with date( in weeks 1 to 52 cycling for 100 years) as my first column and in my second column I have a duration of drought (this is about droughts) if there is no duration it would be left blank

is there a way i could maybe pivot table this into listing me the the duration of droughts for say the weeks.

sorry i know this is hard to understand but heres what i would like my final product to look like

1 16 so if there was a 16, 10 and 13 week drought in week 1 it will list them.
10
13

2
3
4
5
6 5
6
7

my final goal is to calculate conditional probability with 10 rivers ( 10 different spread sheets) once i have this im thinking to do it by hand unless there is any other suggestions.

p.s. this could help agriculture all over the world saving us all money on food!

[shg]

Post a workbook and show an example of what you're trying to do?

[MarvinP]

Hi Jordan,
I agree with shg. We really need an example.

I tried to create what you discribed and it is attached.