Data switching question

[aagustin]

Hi.

I'm in need of some advice. I have a table with multiple fields and I need to take on column's data and rearrange them. Hard to explain but here's what I want to do:

Current:
ID Initial Field1 Field2
1 A Y N
2 B N N
3 C N N
4 D Y Y
5 E N Y

Switched to:

ID Initial Field1 Field2
1 E Y N
2 D N N
3 C N N
4 B Y Y
5 A N Y


So, I need to take the value of the Initial field and switch the top value to the bottom one and vice-versa, without impacting any of the other fields in that row. Anyone know how?

Thanks!