Vectorscript for Hanging position

[fispol01]

Hello,

 

i'm looking for a script that take all hanging position in the document and put it in a worksheet.

I want to concate all fixture attach to hanging position in just one line of a worksheet. For example :

LX1 : ETC source4 (x4), clay Paky (x2)...

LX2 : Clay Paky (x3), ETC 575W (x5)

 

Thanks for reply  

[Sam Jones]

Just a little more clarity.

You want a list of hanging Positions, 1 hanging position per row.  Yes?

You want the cells from column B to list the fixtures attached to that hanging postion.  Yes?

You want one type of Lighting Device plus the total number of that device type to populate each cell (per device type) to the right of column A. Yes?

How do you want to handle Accessories?

[fispol01]

In fact i don't need the accessories...

[fispol01]

16 hours ago, Sam Jones said:

Just a little more clarity.

You want a list of hanging Positions, 1 hanging position per row.  Yes?

You want the cells from column B to list the fixtures attached to that hanging postion.  Yes?

You want one type of Lighting Device plus the total number of that device type to populate each cell (per device type) to the right of column A. Yes?

How do you want to handle Accessories?

It's exactly what i want !

I don't need accessories. 

Thanks a lot