Odd excel usage question:
 

Hey there,

I would like to create a dynamic list from a table with shifting
values.

My data table:

Title1....0
Title2....2
Title3....1
Title4....3

From this data, is there anyway to derive a list that will look like
the following:

Title2
Title2
Title3
Title4
Title4
Title4

.... in such a manner that as the values (0,2,1,3... etc) in the table
above change, the list will change with it?

Many huge thanks. I know this is most likely a bit of a stretch, but
its a design issue that I am trying to deal with and this is the most
effective way I see possible.

Thansk again
-Sean

Odd excel usage question:
 

I would like to create a dynamic list from a table with shifting
values.

My data table:

Title1....0
Title2....2
Title3....1
Title4....3

From this data, is there anyway to derive a list that will look like
the following:

Title2
Title2
Title3
Title4
Title4
Title4

... in such a manner that as the values (0,2,1,3... etc) in the table
above change, the list will change with it?

One way is suggested by the csv file below.

--------------------- cut here -----------------------
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",0,Title1,0
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B1+D1,Title2,2
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B2+D2,Title3,1
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B3+D3,Title4,3
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",=B4+D4,"=""""",
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)",,,
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"
"=VLOOKUP(ROW()-1,B:D,2,TRUE)"