Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this table
col1 col2 col3
A a1 b1 c1
B a2 b2 c2
C a3 b3 c3
I want this
c2 c3
b1 _ _
b3 _ _
I know dragging the coloumn in vertical will do so but how will i get selected choice of b1,b3 from b1,b2,b3 and c2,c3 from c1,c2,c3
help me out
Add listboxes for col2 and col3 and select the values you want. Or use calculated dimensions. Like =if(match(col2, 'b1','b3'),col2)