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?
