I want it to look like the way I have posted it.

The data I have looks like this

Jack 123 dog

Jack 123 cat

Jack 123 cow

Jill 234 cat

Jill 234 pig

Jill 234 sheep

I tried this but mysql does'nt allow and update from statement,so this does'nt work

The field is actually transactiontype which only has 2 values. So this should work.

Thank you so much. This is amazingly concise.Awesome.

Thanks again guys.

Newbie

Number is variable