+ Reply to Thread
Results 1 to 8 of 8

Query multiple lined data into one

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    566

    Query multiple lined data into one

    Hello all,

    Please excuse my ignorance, I am very, very new to Access

    I'd like to query as follows:

    I have the following two tables

    a.png

    b.png

    And I'd liek the outcome of my query to be as follows:

    c.png

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,258

    Re: Query multiple lined data into one

    I used Power Query to achieve your expected results.

    Here is the Mcode. You will need to change the source to your file location

    Please Login or Register  to view this content.
    v A B C D
    1 Field1 Custom Custom.1 Custom.2
    2 77 Andrew John Peter
    3 1205 Andrew John Peter
    4 1345 Andrew John Peter

  3. #3
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    566
    Thank you!
    However I was looking for a non-code way.
    Is that possible?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,258

    Re: Query multiple lined data into one

    This is not VBA. This is Power Query. The code is generated by PQ through manual User Interface Actions. You are working in Access. Your only other choice is to create a SQL statement. I tried that route, but could not come up with a viable SQL statement. A SQL option that I did not try was to create a Union Query. Will play with this a bit longer but am having no success.

    If you wish to learn more about PQ, then click on the link in my signature.
    Last edited by alansidman; 04-23-2020 at 12:01 PM.

  5. #5
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    566
    I see.
    Is it possible to share a screenshot of the manual setting?

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,258

    Re: Query multiple lined data into one

    See attached
    Attached Images Attached Images

  7. #7
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    566

    Re: Query multiple lined data into one

    Thanks you helped me a lot!!!!

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,258

    Re: Query multiple lined data into one

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Lined pivot chart
    By fumusic in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-22-2017, 10:10 PM
  2. Searching for a string in a multi-lined row
    By Saken2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2014, 01:52 AM
  3. [SOLVED] Running sum in a lined chart
    By lampas89 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2013, 05:55 PM
  4. Cell Data Header Only Shows Last Line of Multi-lined Cell Data Header
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 05:40 PM
  5. Combining single rows into multiple lined items
    By bread in forum Excel General
    Replies: 1
    Last Post: 08-31-2009, 12:27 PM
  6. [SOLVED] RE: Question about numbers lined up against dates
    By Mag\(\)\(\) in forum Excel General
    Replies: 0
    Last Post: 05-11-2006, 02:55 PM
  7. [SOLVED] Lined Monthly Calendar
    By tennisolivia in forum Excel General
    Replies: 1
    Last Post: 02-15-2005, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1