convert a MS Access table from mostly columns to mostly rows

Hello. First I will work with your dummy data, create the necessary code, test it on sample access database then deliver you the code. You will be able to run it on your database. Relevant Skills and Experience Access, Excel, VBA Proposed Milestones $155 USD - Will be paid when job is done and customer is 100% satisfied I'm mostly available if you wanna discuss further. Thanks.

Hi! What we need here is a code that will load data from the table and write to new data. This is called "transposing data". It will help if you can send a mockup, with just a few rows of dummy data. Relevant Skills and Experience MS Access professional developer for 24 years, MS Access MVP 2008 and 2009 Proposed Milestones $164 USD - Completed project If you need help creating mockup, let me know! Thanks!

As an expert in ms access related works, i am very much interested to do this work. Looking forward to have a positive response from you. Thanks Relevant Skills and Experience vba Proposed Milestones $80 USD - Initial $80 USD - Final Can you please send me the similar database with some same data and expected output?

Hi there, Without seeing the data or the table itself it's difficult to tell whether an SQL or a VBA script would me more sufficient solution to transpose your data, but I will propose the better one Relevant Skills and Experience I have been working as a data analyst with VBA and SQL skills for 4 years. Proposed Milestones $175 USD - Completion

I read your requirements, We have a Microsoft Access (2007) table that has perhaps 50 columns, and ~1500 rows of information. But I would like to convert (and move the underlying data) most of the columns to rows. Much of the column information repeats to some extent. I would like someone to write what I'm guessing is some simple code to do a 1-time conversion of the table. The table has confidential information that I will not be providing, but I can do a mock-up of the table with some fake column headings, and would ask you to write and provide the code to me (and instructions) so I could execute it for the conversion. Please open PM for discussion. Ponsi

Hi, I can create a macro to convert table data into new table according to specific condition. No matter how many records are there. Macro will detect rows and column numbers. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating Data of Access tables through vba programming. So, can do this job nicely. Stay tuned, I'm still working on this proposal.

Dear sir, I can implement a converter in JAVA. Would like to discuss.. Thanks Relevant Skills and Experience I have implemented Derby to MySQL convertor before.. Proposed Milestones $175 USD - Milestone