# Combing List with the logic as indicated

**URL:** <https://forum.dynamobim.com/t/combing-list-with-the-logic-as-indicated/9734>\
**Category:** Revit\
**Created:** [February 18, 2017, 1:10pm UTC](https://forum.dynamobim.com/t/combing-list-with-the-logic-as-indicated/9734 "2017-02-18T13:10:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kvusal](https://avatars.discourse-cdn.com/v4/letter/k/47e85d/32.png) [@kvusal](https://forum.dynamobim.com/u/kvusal)\
**Post date:** [February 18, 2017, 1:10pm UTC](https://forum.dynamobim.com/t/combing-list-with-the-logic-as-indicated/9734/1 "2017-02-18T13:10:59Z")

</div>

Dear Dynamo Team,  
I was trying to combine 3 list with the logic indicated in the screenshot. One of the List is header. Other two list are sheet thickness and its quantity. I need to make sheet thickness and quantity to be in the same level so that to write it to excel properly.  
I also sent you Dynamo file to check. Your help will be appreciated.

[Duct List BOQ.dyn](https://forum.dynamobim.com/uploads/short-url/bGV8cenX6LuqhQPrpFRJgkTO2IZ.dyn) (4.8 KB)

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/0/20c07e5058bcaa4bef76210b327710931a75a215.png)

---

<div class="post-metadata">

**Author:** ![Einar\_Raknes](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/einar_raknes/32/8566_2.png) [@Einar\_Raknes](https://forum.dynamobim.com/u/Einar_Raknes)\
**Post date:** [February 18, 2017, 1:56pm UTC](https://forum.dynamobim.com/t/combing-list-with-the-logic-as-indicated/9734/2 "2017-02-18T13:56:13Z")

</div>

Hi @kvusal!

The typical steps in a very common task like is

1. List.Create (put the different list of data into one list with sublists)
2. Transpose (shift rows and columns)
3. Add Item to front (put the heading to the lists)

You take this one step further and want to do the same for three list at the same time, then for the most part you can play with the list levels @Lx, but for some of the nodes this is not supported yet, and you need to resort to the good old List.Combine.

Here is how I solved it:

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/0/903711bad8b541dc99fb96c99b00ee1cda20993d.png)

[Duct List BOQ.dyn](https://forum.dynamobim.com/uploads/short-url/pA2YK2GA3HVvpx44ZSpwbb2Y0iz.dyn) (10.6 KB)

---

<div class="post-metadata">

**Author:** ![kvusal](https://avatars.discourse-cdn.com/v4/letter/k/47e85d/32.png) [@kvusal](https://forum.dynamobim.com/u/kvusal)\
**Post date:** [February 18, 2017, 9:01pm UTC](https://forum.dynamobim.com/t/combing-list-with-the-logic-as-indicated/9734/3 "2017-02-18T21:01:02Z")

</div>

Thanks a lot Dear Einar! 🙂
