Hello Brano, > I have small databaze in EXCEL. I want send informations to my > friends... now I want to convert it to this format... I dont know > how to do it
IMHO, your post is off-topic for this list. I'll post my reply and then sign off. If you're trying to convert column-wise data to row-wise data, you can do it quite easily in Excel. I'm still using Excel 97, but these instructions will surely work in any subsequent version. Select the column-wise data, press Ctrl-C, move the cursor to a clear area of the worksheet where you want the row-wise data to appear, click on Edit, Paste Special, select the Transpose checkbox, click on OK. The row-wise data will now appear in the worksheet. If you want the row-wise data to consist of the field names and a single value, I believe you'll need to use a macro as I don't know of a simple way to do this. However, what you're trying to do requires only an _extremely_ simple database query. My advice, then, is to export your data to Access, perform your query there, and export to text or Excel. If you want some more help, I suggest you contact me privately. regards, Andy [Using The Bat! 1.62r under Windows 2000 Pro SP4 on a "made from scratch" P4-2.4 GHz/512 MB RAM] ________________________________________________________ http://www.silverstones.com/thebat/TBUDLInfo.html
