silviu30 Posted February 19, 2009 Share Posted February 19, 2009 i extracted block attributes using the extract attributes wizard and i want to exchange the rows with colums in order to make an excel report can somone explain me how can i do it Thanks Quote Link to comment Share on other sites More sharing options...
darn-net Posted February 19, 2009 Share Posted February 19, 2009 After your data is in excel. You can do this two ways that I could find. 1. Select the data, copy, then "Paste Special" selecting the "Transpose" check box. 2. You can set up a formula to do this using Transpose. I tried a quick test with this method and didn't get it to work. Here's a link i found in a search. http://www.techonthenet.com/excel/formulas/transpose.php Dave "Most of what I know came from the "F1" key" Quote Link to comment Share on other sites More sharing options...
CmdrDuh Posted February 19, 2009 Share Posted February 19, 2009 do you program any? You can extract from Acad to excell using VBA, and put the values where ever you want in excell Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.