transposition dependent on row contents

[trilliansounds]

Hi,

I've been searching through the forum for a way to do this... I can't believe this hasn't been covered before so pls excuse the double post. I've a set of data of 1000s of rows and two columns (A & B) and would like to transpose the information into multiple columns whenever the data in column A changes.

so from:

X 140
X 22
X 500
Y 33
Y 5
Z 1

I get this:

Column A     Column B     Column C
    X             Y              Z
   22             5              1
   140           33
   500

Attached a spreadsheet with some more data - if the translated information can be automatically sorted by ascending as well that would be fantastic.

Thanks for your help