+ Reply to Thread
Results 1 to 3 of 3

Multiple rows data into one row and different sheets

  1. #1
    Registered User
    Join Date
    04-21-2016
    Location
    Pakistan
    MS-Off Ver
    2013
    Posts
    2

    Multiple rows data into one row and different sheets

    Greetings All

    kindly note before reading

    Pardon the English, not my first language.

    This link contains the excel data dump is dummy data, due to confidential nature of data i cannot share the original however replaced using formulas and supplements the original values


    ================
    i need help in sorting out data for mail merge which is recurring monthly.

    i have to email all my retailers nationwide to ask them if the members data is valid and if there is any changes in the data.

    i have to extract the data for each customer and have it arranged into single rows against every retailer, i.e

    customer ID "aaaab.aaa1" and number of members "1" and his rest of the information in that row, which is already in sorted in the data

    now i have many retailers that have more then 1 number of members. i,e aaa.aaab101 have data of two separate members in two different rows.

    these two or more then two customers data need to appear in single row respectively i.e, customer ID "aaa.aaab101" have two members Customer 191 and Customer 195. first data set of Customer 191 followed by Customer 191
    same applied for 3, 4, 5 till 10 members.

    further more the data for number of customers need to appear in separate sheets, i.e 1 member in "1 member sheet", 2 members in "2 member sheet", 3 member in "3 member sheet" and so on. sample is included in the file


    =========


    feel free to ask any questions and i will get back to you as soon as possible.
    Last edited by bilal-dropbox; 04-22-2016 at 06:40 AM.

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Multiple rows data into one row and different sheets

    Hi
    Use the sheet 'May-16' a help column, R column, the formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    for the 'costumer ID' with a prefix equal to the sequence of members that constitute it.
    Create the necessary sheets to transfer the desired information.
    In each of the sheets helps create two columns, columns U and W.
    Use the U column formula (U2: U711)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Use the W column formula (W2: W711)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    V1 is the number of members
    A2 use the formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    which can be copied to the range A2: Q711
    See the attached file Source Data(1).xlsx
    Best Regards

  3. #3
    Registered User
    Join Date
    04-21-2016
    Location
    Pakistan
    MS-Off Ver
    2013
    Posts
    2

    Re: Multiple rows data into one row and different sheets

    Dear Josť

    Thank you for your time and effort. Appreciate your help and would request further support.

    the solution provided address to half of what result i am looking for.

    the resulting data set is in rows with respect to name member to single customer.

    what I am hoping is data set for single customer id (Column C) and data of two or more then two members need to show in that single row one after another. (kindly view sample sheet in original "source data" file.

+ 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] Moving rows of data to multiple sheets based on status
    By sthiessen85 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2015, 01:21 PM
  2. How to select rows based on data in a column off multiple sheets?
    By wdwinterfang in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-20-2013, 11:51 PM
  3. Help keeping data intact even when adding rows across multiple sheets
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2013, 09:20 AM
  4. Pulling Data from multiple sheets and inserting rows
    By jMedia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 03:03 PM
  5. RE: Extracting Data from multiple sheets/rows
    By stuckinlondon in forum Excel General
    Replies: 3
    Last Post: 09-24-2011, 10:56 AM
  6. RE: Extracting Data from multiple sheets/rows
    By stuckinlondon in forum Excel General
    Replies: 4
    Last Post: 08-19-2011, 09:09 AM
  7. Want to combine columns in rows where data exists from multiple sheets into one
    By bugmenot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2009, 08:27 PM

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