Hey All,

The attached file is a sample of what I need to do. Sheet one is original format and sheet two is what I want.

Basically the original format is a long list of data, and I need to put each observation into a row, while putting the values into the correct columns. The few tricky points are that for the "AU","AI","DE","KW","AF", the numbers vary for different observations. Some observations have just one each, but some have 2,or 3 or more, so in the list, each observation takes up a different length of range. For those that have multiple "AU"'s, the table version would need to have "AU_1", "AU_2"....

I have an idea about how to achieve this, but I have little experience with VBA, so I don't even know how to get started. Can I say something like: (not in VBA codes)

i=1, j=0

For i<=100000:

Look at Ai,

if Ai="$$":

j=j+1

i=i+1

if Ai="AN", then let Aj(in sheet 2)= Bi(in sheet 1)

i=i+1

if Ai="ST", then let Bj (in sheet 2)=Bi(in sheet 1)

i=i+1

...

....

if Ai="AU", if Gj = "", Gj=Bi

if Gj !="", if Ij="", Ij=Bi

if Ij != "", if Kj="", Kj=Bi.....

i=i+1

if Ai="AI", .....

and so on,,

you get the idea, I know this is probably the most inefficient way to do it, but even so I don't know how to write out the code.. Any help would be appreciated!!!

Thanks!!

also posted on http://forum.chandoo.org/threa…-table-please-help.12720/