+ Reply to Thread
Results 1 to 12 of 12

Vertically data into horizontally of repeated numbers

  1. #1
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Vertically data into horizontally of repeated numbers

    Good day All

    PFA, i want, there are repeated numbers in column "A" and in column "C" the services are different.pl make all services name in front of number horizontally means repeated numbers turn into single and all services name of column c become to horizontally in front of number.

    Gondal
    Attached Files Attached Files

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Vertically data into horizontally of repeated numbers

    Try this:-
    If this is not the Results you want please , Post Example of expected results.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Re: Vertically data into horizontally of repeated numbers

    dear Mick

    this is good but last column services are repeating and only 4GLTE_C showing instead of complete text and some of services are missing like see number 3246796470 on word..


    Gondal
    Last edited by gondal; 08-04-2016 at 06:55 AM.

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Vertically data into horizontally of repeated numbers

    Try this (Less Duplicates)
    The number 3246796470 start line 51 in results


    I Don't understand this, Please explain using example of expected results.
    and only 4GLTE_C showing instead of complete text
    Please Login or Register  to view this content.
    Regards Mick
    Last edited by MickG; 08-04-2016 at 08:56 AM.

  5. #5
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Re: Vertically data into horizontally of repeated numbers

    dear mick
    given VBA is showing error that script out of range..pl attached i need result in sheet 1...your provided sheet is good but have some errors

    gondal
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Re: Vertically data into horizontally of repeated numbers

    thnx mick bro..

    now its fine and working, pl tell this data is as help. if data is large and less will this macro work..?because i am using in other sheet its not working..pl see attached
    can make you general for all..


    Gondal
    Attached Files Attached Files
    Last edited by gondal; 08-04-2016 at 09:29 AM.

  7. #7
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Vertically data into horizontally of repeated numbers

    Try these 2 codes Then tell me your problems !!!
    Attached Files Attached Files
    Last edited by MickG; 08-04-2016 at 09:48 AM.

  8. #8
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Re: Vertically data into horizontally of repeated numbers

    dear mick master

    thnx for helping me out..results are good and accurate now but there is two problem i have only now pl make same name services in same column other than other column and have a look in post 6 that why VBA is not effective or working in that sheet.
    gonda;
    Last edited by gondal; 08-04-2016 at 10:45 AM.

  9. #9
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Vertically data into horizontally of repeated numbers

    Try this On "Help_Copy1"
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Re: Vertically data into horizontally of repeated numbers

    thnx mick master

    every time VBA need to change as per sheet..?? pl make same name services in one column (vertically) other than other column..

    Gondal

  11. #11
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Vertically data into horizontally of repeated numbers

    Sorry, I've no idea what that means !!!!

  12. #12
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    Re: Vertically data into horizontally of repeated numbers

    dear mick..

    pl see attached .can you provide result like in attached sheet 2..otherwise i have to go with it and this is good and enough help for me from your side master class

    gondal
    Attached Files Attached Files

+ 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. Display data horizontally not vertically through VBA
    By webanalytics1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-27-2015, 10:44 AM
  2. Excel Macro To Move Data Horizontally from Vertically Organized....
    By SeanEboy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2015, 01:48 PM
  3. [SOLVED] transpose and consolidate data horizontally to vertically
    By Excel_learner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2014, 03:50 PM
  4. [SOLVED] Importing Excel Files & Copying Data Horizontally (instead of vertically) Help!
    By WinNuke95 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 01-22-2014, 10:11 AM
  5. Replies: 5
    Last Post: 01-27-2013, 09:36 PM
  6. Excel 2007 : Merging data horizontally vs. vertically
    By enhydra in forum Excel General
    Replies: 4
    Last Post: 12-12-2010, 06:16 PM
  7. A tough one! line up vertically/horizontally through data
    By djvice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2005, 04:32 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