This was going to go into a LOAD statement using QlikView (which uses SQL syntax) but just didn't work the way that I wanted it to so I had to...

Didn't work, but thanks.

This doesn't work. I only need the year part and it's not a char.

Yes, got it, thank you!

Awesome, that worked! Thank you so much!

Thanks! I feel a union all would work too but it just doesn't. I have temp tables and I think that is what is messing it up. Here...

Awww how sad for you. You must think nobody works in education. How narrow minded of you.

If grade isnumeric then grade type is numeric so use that row of values, else it must be alpha

Thanks! That worked!

I took the headers out. That's why I'm having trouble.

Never mind, I was missing some parentheses.

Thanks. I ended up doing the second option with the filter.

Current Column

Big

Big

Big

Small

Small

Big

Small

Small

Big

Big

Small

Big

Small

I would like to have:

Column 1

Big

Big

Big

Big

Big

Big

Big

Column 2

Small

Small

Small

Small

Small

Small

Neither. They are alternating values. One cell will say "Big" then the next cell may say "Small." So I was wanting to make two columns where the expression...

Actually I think I would just filter out the values with an expression. Now, I'm not sure which expression. I don't think and IIF would work. What would the expression...