Community
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 |
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.