Results 1 to 3 of 3

Duplicate Rows Into One Row

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    2

    Duplicate Rows Into One Row

    Ok, I have multiple sheets. Let's get right down to it.

    This is what I have:

    1111111111   ATT   AT&T Data Usage (kb)	                                $0.00
    1111111111   ATT   ATT Blackberry Unlimited Data Add-On Plan	$36.90
    1111111111   ATT   ATT Bundle Flex Credit	                               -$34.03
    1111111111   ATT   ATT Voice Plan With Bundle	                $27.88
    1111111111   ATT   ATT Text Messaging Unlimited Package         $16.40
    1111111111   ATT   ATT Wireless	                                $0.00
    1111111111   ATT   ATT Wireless Priority Service	                $3.69
    This is what I want:

    1111111111   ATT   AT&T Data Usage (kb)  $0.00 ATT Blackberry Unlimited Data Add-On Plan  $36.90 ATT Bundle Flex Credit  -$34.03 ATT Voice Plan With Bundle  $27.88  ATT Text Messaging Unlimited Package  $16.40  ATT Wireless  $0.00  ATT Wireless Priority Service  $3.69
    I don't know a thing about VB, Macro's or anything.....doing this all by hand.....and I have 3 sheets of over 20,000 lines....any help would be amazing and a job saver.

    I've attached a spreadsheet with an example.

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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