Thanks Jeff. I'll try that out.
"Jeff Boyce" wrote:
[Quoted Text] > Theresa > > I believe what you're looking for is termed a "normalizing query". > Actually, you'd need several queries, one for each column you are > converting. > > Create your new table structure. Create your (first) query to append the > first Project# column and Facility to your new table. Make a copy of that > query and change it to get the second Project# column ... and append. > Repeat until all Project# columns have been appended. > > -- > Regards > > Jeff Boyce > Microsoft Office/Access MVP > http://mvp.support.microsoft.com/> > Microsoft IT Academy Program Mentor > http://microsoftitacademy.com/> > Microsoft Registered Partner > https://partner.microsoft.com/> > > "Theresa Pistochini" <Theresa Pistochini[ at ]discussions.microsoft.com> wrote in > message news:98939A64-4343-4B01-9F5C-88530ED514EF[ at ]microsoft.com... > > I have an output table generated by a web based form that looks like this > > (example): > > > > Facility Project 1 info. Project 2 info etc.... > > LabA abc def > > > > I want to map this into a table that looks like this > > > > Facility Project info > > LabA abc > > LabA def > > > > So basically I want to convert one long array of data into less columns > with > > multiple rows. Can someone push me in the right direction on how to go > about > > this? > > > > Thanks in advance. > > ~Theresa > > |