Forum Discussion

kd_07's avatar
kd_07
Copper Contributor
Dec 13, 2018

HELP PLEASE!! I need to create a table that automatically adds lines dependant on data in columns?!

I dont think the title helps me much.  I am at a complete loss ! 

I have a table e.g:

 

Customer     Ref     Name     Cut1    Qty1    Cut2     Qty2 etc

xxxxx            123     cu              1         1           2        3

yyyyy            456     cu              2         1           3        2 

 

I need to create a new table that combines all this data but has one 'Cut' column and one 'Qty' column so that cut2 and qty2 are on the row below cut1 and qty1 etc etc

it therefore needs additional rows :

 

Customer     Ref     Name     Cut    Qty

xxxxx            123     cu             1       1   

xxxxx            123     cu             2       3

yyyyy            456     cu             2      1

yyyyy            456     cu             3       2

 

there are over 19 cut and qty columns.  It would also need to be linked to the original table as this is updated regularly.  

what can i do?

Resources