Append last 3 columns of data if column B dup

Closed
JFB - Jun 9, 2010 at 02:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 03:38 PM
Hello,

I've come close to making this work, but I can't quite get it right. I have a spreadsheet with customer acct # in column B-- we receive the data with various entries for the acct #. Sometimes there is only 1 listing per acct; sometimes 9. I need the last 3 columns (V,W, and X) copied to the end of the first entry for that acct #. --EXAMPLE-
B (acct#) ....... V W X Y Z AA AB AC AD
479930 cse eft wnr
479930 ors eda lgd
479930 wsl lof sfe
495032 swf sfg fde

I am trying to get the 2nd entry "ors eda ldg" inserted into columns Y, Z, AA --- and then the 3rd entry "wsl lof sfe" appended to the end of that data (columns AB, AC, AD) -- I need this done for each duplicate acct # in column B -- basically, I need every acct # to be on just one row (column B thru U is the same for duplicate acct #'s- only the last 3 [V,W,X] change)

thank you
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 9, 2010 at 03:38 PM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0