Howdy,
I have a table that shows a set of possible combinations, but in order to actually use it, I need to make it a list.
The table is like
Sample Table Origin.gif
And the wanted result is like
Sample List RESULT.gif
Which means,
FIRST: Several columns (SKU, CODE, DESCRIPTION), making a "three column row"
THEN: If you have a number 1-one, you make de combination of the column TITLE (red) with the "three column row" PLUS the second column TITLE (blue)
Which means that each table ROW, can make up to 4 LIST rows in this example (1:4).
Real life, I have "six column row" 9 reds (and growing) and 16 blues (and growing), giving a good 1:144 :-S
So far, I've found how to make, from the origin table a 3 column list (NOT WANTED)
Sample List NOT wanted result.gif
(NOT WANTED)
The above (not wanted) result came from http://michiel.wordpress.com/2009/03...bles-to-lists/
Any ideas??Please Login or Register to view this content.
As required, you can find the sample xls here http://www.sendspace.com/file/pjen9x
Bookmarks