How to populate excel cells from horizontal to vertical by using linq query

[Sathish_Kumar5 (Sathish Kumar)]

1. First condition - if qty1 has 1.00 then it needs to check whether combo has values if so, it has then needs to get combo 1 value and combo 2 value and combo 3 value so if any of combo contains ( - ) then it shouldn’t take combo value and ignore. so after taking the combo values it should append it vertically in another excel or need linq to append to data table

2. second condition
   if qty1 is 2.00 or 3.00 then then it needs to divide the (rate without tax) with their qty number for example if it is 2.00 then 415.26 and split in two 207.63 and 207.63 and if it is 3.00 it needs to spit it into three halfs and append it in excel also get combo value and if qty is 2.00 it needs to repeat two times of combo1 value and if qty is 3.00 and it needs to repeat three times of combo1 value and append it vertically then if qty is 2.00 it needs needs to repeat two times of combo 1 and append it vertically.