Stacking data into one column based on unique values and multiple source columns

Hi,

My question is based on stacking data into one column based on three columns and unique values. Kindly refer to the attached excel for example. The trick that I am looking for is that if new unique cost object is added, then the column where the stack is would be updated to reflect this. For example now I have 6 rows for Value column one, this is since I have three unique values (output displayed twice) if there would be four unique cost objects then I would have 8 rows for one value column. This process would be repeated for value columns two and three in order to have the data in one huge column stack.

Br,
Ville

I am still stuck with this, anyone ideas?

See the attached:

in J2 and copy down:

=IFERROR(IF(K2="","",INDEX($B$3:$B$20,MOD(ROWS($A$1:A1)-1,$G$2*2)+1)),"")

in K2 and copy down

=IFERROR(INDEX($C$2:$F$2,,INT((ROWS($A$1:A1)-1)/($G$2*2))+1),"")

in L2

=SUMPRODUCT(($C$3:$F$10)*($B$3:$B$10=$J2)*($C$2:$F$2=$K2))


Note formulae use formula in G2 for count of unique values. I also changed the order of data in Input Data table

I added some additions , including counts of both unique rows and columns, both of which are used in the formulae.

the table will automatically change with additions/deletions to rows and/or columns.