Need Macro to Turn Rows of Data Into Columns of Data

At my old company one of my staff members built an Access macro that would take multiple records for the same entity and display that data horizontally on one row. His macro allowed for up to 20 fields per record (30 would be great but 20 is fine).

Step 1. Macro imports a .txt file or Excel worksheet (he set up 2 different macros depending on import file type but for expedience if just a tab delimited text import macro is developed that's fine) that has two fields only. The duplicate field (say employee ID) and the field that needs to be displayed horizontally (say employee committee name). I would be the one generating the input file each time. It's content agnostic. Always text fields only with standard text field limits (250 characters I believe?).

Step 2. Macro does its job and produces an Access table with the resulting data.

Input file looks like this (this is just an example not the actual field names):

Employee # Committee Name

1234 Finance

1234 Volunteer

1234 Recycling

1234 Employee Survey

5511 Volunteer

5511 Recycling

Output TABLE (housed in the same database) looks like this:

Employee # Committee 1 Committee 2 Committee 3 Committee4

1234 Finance Volunteer Recycling Employee Survey

5511 Volunteer Recycling

Now this is purely a tool I need to do other work in Excel. Function over style. Doesn't have to have any slick interface (or any interface), just imports a txt tab delimited file in from a specified location (preferably from "Documents" folder on my hard drive - Windows 7 OS). Even the output fields on the table can be called Field 1, Field 2 etc. This is just a tool to do data manipulation. Input file will never exceed the row limit in Excel (just to give you an idea of scale).

Not sure how this works (first time) but I assume bids come in to my e-mail. I need this ASAP. Someone may already have something like this built, fine with me. As long as it works per the specs above I'm good.

Using MS Access 2010



Compétences : Excel, Microsoft Access, Microsoft Outlook, Serveur SQL Microsoft, Sharepoint

en voir plus : up to standard, survey interface, i need employee, how excel works, first volunteer, excel macro how to, excel macro file location, exceed database, data access interface, need macro compare data, excel macro match data columns, macro pasting data columns, compare rows macro columns, need excel macro input data, excel macro copy data column, excel macro move data existing cell, macro extract data, macro gets data website

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #8487981

30 freelance font une offre moyenne de $100 pour ce travail


ID : 8487981 Greetings, We are interested to work on this project, please find my comments inline with yours, [url removed, login to view] my old company one of my staff members built an Access macro that would take multiple records for Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(213 Commentaires)

HI, This seems to be hardly couple of hours work for Excel/Acess expert. I am available to start work on this now and will provide output in couple of hours. Lets discuss the project in bit more detail. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(159 Commentaires)

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excei :) via VBA macro Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sinc Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(128 Commentaires)

Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on writing several Macros and can help you out with the requirement. Waiting for your response to talk Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(73 Commentaires)

hello Todd, this is doable...please share your Access file, we can get you a macro for this....thank you..

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(120 Commentaires)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(70 Commentaires)

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you’d like to built an Access macro that would take multiple records for the same entity and display that data horizontally o Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(38 Commentaires)

Hi, I hv an idea about this work.. I can do it very well I hope u ll like to discuss more.. awaiting for ur response,, thanks & regards Mir

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(46 Commentaires)

Dear Client, I am like to purpose to upgrade your current system, so it can export those records to MS-Excel. Your old system will work as usual and there will be export functionality which will open the MS-Excel Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(6 Commentaires)

Hi I am an experienced Excel/Access vba developer having expertise in smart data solution development. I can create an amazing tool which will import data and create output as per your specs. Please check my feedback Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(21 Commentaires)

i can complete it within 24H and can send first draft for your test within ~2-4 hours after awarding if my proposal is ok with you please send the txt examples and create milestone payments

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(31 Commentaires)

Hello, I have been working as freelancer since last ~ 2.5 years, prior to this was working with a MNC as a Sr. Software Professional. The project is Product based development and integration of the product with v Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)

I am very interested in working online for you. I am interested in long term work. I have had 5+ years exp. in Computers, MS word, MS excel, Quickbooks, Office Management , PDF, Google spreadsheet Powerpoint, Vba and t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(19 Commentaires)

Hello, I’m newer to this freelancing website and am just beginning to build my online reputation and client base. Over the past 17 years, I’ve worked in a variety of functions spanning Information Technology, Suppl Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)

I think this can be done directly in Excel without the need for Access at all. What you are doing is pivoting the data. A simple pivot would create a table with a column for each committee and loads of empty columns Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)

Hi Todd, As far as I understood, you need an Excel macro which would read tab-delimeted txt file and populate Excel sheet with data which has rows transferred into columns. If that's your requirement, then the projec Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(8 Commentaires)

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)

I have implemented several complex macros. I would like to work with you. please let me know further. Regards, Selvan

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)