+ Reply to Thread
Results 1 to 7 of 7

I am facing a problem to combine data in several colomns ignoring the blank sells

  1. #1
    Registered User
    Join Date
    04-19-2019
    Location
    hyderabad
    MS-Off Ver
    2008
    Posts
    3

    I am facing a problem to combine data in several colomns ignoring the blank sells

    Hello dear friends
    i am facing a problem in compiling a data. the data i have is an extract from a sheet. the data in question is pertaining to an institute. the data i have is placed leaving few rows blank and data is spread across. it appears as follows:
    Date Name From Contact Number Course Paid GST TOTAL
    15-04-19 Client1 KNR 7032720820 Basic Beauty Course 1200 216 1416

    15-04-19 Client4 KNR 7032720820 Basic Beauty Course 10000 1800 11800


    15-04-19 Client6 KNR 7032720820 Moderate Beauty Course 20000 3600 23600


    15-04-19 Client9 KNR 7032720820 Advance Beauty Course 40000 7200 47200


    15-04-19 Client12 KNR 7032720820 Special Beauty Course 60000 10800 70800


    15-04-19 Client15 KNR 7032720820 Advance Beauty Course 40000 7200 47200

    what i am to prepare is the data as follows:
    Date Name From Contact Number Course Paid GST TOTAL
    15-04-19 Client1 KNR 7032720820 Basic Beauty Course 1200 216 1416
    15-04-19 Client4 KNR 7032720820 Basic Beauty Course 10000 1800 11800
    15-04-19 Client6 KNR 7032720820 Moderate Beauty Course 20000 3600 23600
    15-04-19 Client9 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client12 KNR 7032720820 Special Beauty Course 60000 10800 70800
    15-04-19 Client15 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client18 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client21 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client24 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client27 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client30 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client33 KNR 7032720820 Advance Beauty Course 40000 7200 47200
    15-04-19 Client36 KNR 7032720820 Advance Beauty Course 40000 7200 47200


    I need to bring the data in a continuous form ignoring the blank rows.
    advance thanks for the help
    Regards
    Sriram
    Last edited by sriram1970; 04-21-2019 at 12:02 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: I am facing a problem to combine data in several colomns ignoring the blank sells

    Welcome to the forum!

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-19-2019
    Location
    hyderabad
    MS-Off Ver
    2008
    Posts
    3

    Re: I am facing a problem to combine data in several colomns ignoring the blank sells

    Dear AliGW

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution. - THE DATA PROVIDED IS REPRESENTATIVE OF REAL DATA.

    2. Make sure that your desired results are also shown (mock up the results manually). I HAVE CLEARLY PASTED THE RESULTS I AM LOOKING AT

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.). THE DATA IS DUMMY ONLY

    4. Try to avoid using merged cells as they cause lots of problems. THERE ARE NO MERGED CELLS IN THE SAID DATA

    LOOK FORWARD TO READ FROM YOU
    THANK YOU IN ADVANCE
    REGARDS
    SRIRAM

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: I am facing a problem to combine data in several colomns ignoring the blank sells

    @sriram1970

    The primary reason to ask for you to upload a sample workbook is that no one here wants to re-type your data to try and solve your issue. We have no way of knowing how the data is formatted when presented as you have. We are all busy people with lives apart from this Forum and we take our limited time to help you. If you are unwilling to help us help you, then.......who knows what type of response you will receive.

    Additionally, from your presentation, it is difficult to determine what columns hold which information as all information is run together.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Registered User
    Join Date
    04-19-2019
    Location
    hyderabad
    MS-Off Ver
    2008
    Posts
    3

    Re: I am facing a problem to combine data in several colomns ignoring the blank sells

    Sir, I fully agree with you and i respect your view also, but i am unable to upload the file, the option of uploading the file is not working..
    Regards
    Sriram

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: I am facing a problem to combine data in several colomns ignoring the blank sells

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: I am facing a problem to combine data in several colomns ignoring the blank sells

    Quote Originally Posted by sriram1970 View Post
    Sir, I fully agree with you and i respect your view also, but i am unable to upload the file, the option of uploading the file is not working..
    Regards
    Sriram
    Reasons for providing a workbook and instructions are all in my post. Please read it again properly.

+ 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. Replies: 2
    Last Post: 09-29-2016, 10:49 AM
  2. Replies: 5
    Last Post: 08-07-2014, 12:37 PM
  3. Facing problem while saving data in desired cell in excel sheet from your form
    By Harmeet Singh in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-23-2013, 03:39 AM
  4. [SOLVED] Facing Problem with VBA Excel on Pulling data
    By nitesh_greatie in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-17-2013, 03:05 AM
  5. Facing problem in excel while copying data from one sheet to another sheet
    By krasathi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2012, 04:40 AM
  6. VBA Program problem facing
    By Anshuman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2009, 01:21 PM
  7. [SOLVED] facing formula problem
    By thinkpic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM

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