Duplicate Rows Into One Row

**bigbonebuddy2007** · 07-28-2011, 02:31 PM

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.

**imav** · 07-28-2011, 02:47 PM

Originally Posted by bigbonebuddy2007

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 am not sure I understand what you are trying to accomplish here...

...can you refine your question?

-
imav

**bigbonebuddy2007** · 07-28-2011, 02:54 PM

Imav,

Essentially, I have sheets with a thousands of duplicates in column A (1111111111) Column B is to remain the same. Column C (AT&T Data Usage (kb)) and column D need to be moved onto the first row of the first unique value as specified by column A. 1111111111 is a phone number. And each phone number has multiple lines of plan names and plan rates. I need the plan names and plan rates on the first line of the phone number so that the order of information is Phone Number - Carrier - Plan Name 1 - Rate 1 - Plan Name 2 - Rate 2 etc.

There are phone numbers with only one additional row. And there are phone numbers with up to 10 additional rows. I only need one row for each phone number with the multiple plan names and rates on that row.

The sample Excel sheet I've attached will explain it better.