Google-sheets – Get Published Google Doc in JSON

Possible but may require some 'compromising':

=arrayformula(right(split(FILTER(B3:B, A3:A>0, LEN(B3:B)>0), ","),1))  

in D1 to F10 does find the 2 (which should have been 'underneath' where you put your formula for the purposes of your example) - it also strips out Value, though this could be added back later if required.

in say G1 and copied down to suit:

=arrayformula(LARGE(value(D$1:F$10),row()))  

then with all your values in a single column, in say H1 and copied down to suit (upto #NUM!):

=unique(G:G)  

The results will be in reverse order from as shown by you (sort?) because of use of LARGE rather than SMALL because if positive values only all the 0 would have come first and there are quite a few of those.

Concatenate results with ="Value "&H1 etc if required.

You are grabbing too much of the spreadsheet key...Try this piece:

0AupKcedJ0nhPdFFyMVhySWNvNzlYTV9RZ1FmYXdKc0E

So your line should read:

=importrange("0AupKcedJ0nhPdFFyMVhySWNvNzlYTV9RZ1FmYXdKc0E","sheet2!E9:E9")

This answer on Web Applications, explains the IMPORTRANGE in detail.