vlookup reference short cuts

[mickedog]

i'm playing with a list that i want printed a certain way. when
condition is true, it puts my data in the cell.

right now i have 6 things releated to that reference and i want to pu
them vertical.

ex

1 data1 data2 data3 data4 data5 data6

thats my first row of many

now i want it to go vertical if its true to my terms

data1
data2
....

as of now i thought making a col of numbers to refer

a b
1 1 vlookup(a1,data,1)
2 1 vlookup(a2,data,2)
3 1
4 1 i have 6 1's for 6 colums of data
5 1
6 1
7 2
8 2
9 2
10 2
11 2
12 2

this works ok, just seems sloppy and leaves spaces that i have t
filter

i would pefer not to use filters or macros, just plain functions t
sort out my data and put it in a differnt forma

 

[Frank Kabel]

Hi
if you don't want to have blank lines in between you probably need VBA
for creating this list.

 

[Dave Peterson]

Maybe you could apply Data|filter|autofilter.

filter to show non-blanks and then print.

Then data|filter|showall to, er, show all the data.

 

[mickedog]

=IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange)-COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL((IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))

this will take care of blank spaces, i found it here
http://www.cpearson.com/excel/noblanks.htm

the problem i'm having is i want to build a list from a list?

ex


1 data1 data2 data3
2 data4 data1 data0

I want to put this data someplace else like this

this would be record 1
= if (i want it,data1,"")
= data2
= data3

and then record 2 would go right below that

so i'm making a single col list from an array of data