Heh... wait a minute now. You want this to all be done in a view? If so, what do you want to be filled in for the other 22 columns if you only have 3 columns to work with?
My recommendation would be to not to try to solve this problem with a view because there's no way to control the number of columns returned in a view.
--Jeff Moden
Change is inevitable... Change for the better is not.