Append last 3 columns of data if column B dup [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!