Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how do I create a single list box from the column values of multiple columns
please let me know
Here it is
SCHOOL: LOAD * INLINE [ ID, DATE, Subject,Teacher, Class 1, Class 2, Class 3 1, 1/1/2015,Physics, Tom, Vicky, John, Sam, 2,1/2/2015,Math, Eric, Nickr, Vicky, Kevin, 3,1/3/2015,Science, Catalina, Kevin, Zara, Null, ]; CROSSTABLE (Class, Student,1) LOAD [Class 1], [Class 2], [Class 3] RESIDENT SCHOOL; Tution: LOAD * INLINE [ Subject, Date Physics, 1/2/2015 Math, 2/3/2015 Science, 3/1/2015 ];