I need to transpose some data that I bring in via a microsoft query, however
when I do the copy and special paste it works properly the first time,
whenever i update the query, the transposed special paste goes back to the
orginal format. Is there anyway to do this?

Terry