data extraction from dynamic blocks

[Anonymous]

Hello,

In my dynamic block, there are 6 different visibility of a wardrobe with 6 different prices. When I extract a data, I want to see the prices in excel row by row in a one column. However Autocad shows them in 3 column as below:

Count	Name	PRICE	PRICE(1)	PRICE(2)	Visibility
1	Block Wardrobe	200 YTL	150 YTL	350 YTL	3
1	Block Wardrobe	200 YTL	150 YTL	350 YTL	2
1	Block Wardrobe	200 YTL	150 YTL	350 YTL	1

[steven-g]

That is how data is extracted.

You get

A B C D E

A B C D E

A B C D E

etc.

If you want

A A A

B B B

C C C

D D D

E E E

etc. Then you will need to do that from within excel. The easiest way would be to copy the data in excel go to a new sheet and use paste-transpose, and where that is varies with different versions of excel.