Wednesday, February 5, 2014

yogi_Rearrange MultiColumn Entries For Asociated Entities According To DataBase (List) Rules

                                         Google Spreadsheet   Post  #1517
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-05-2014
post by Tidoko and question by Daniel  (!msg/docs/mLcdO0c2QEc/F7yNO9wdhVsJ)

Hi --Hyde,
Thank you for sharing your knowledge!

Hi have a table like this, but with lots of data !

ABKI 1000ABKI 2000ABKI 3000
John02/04/2014 18:46:0002/04/2014 18:46:00140170200
Mark02/04/2014 18:46:0002/04/2014 18:47:00200230250
Peter02/04/2014 18:47:0002/04/2014 18:47:00405060

and I need to convert the data in red to single rows combining its relative information.
So it would be something like:

John02/04/2014 18:46:0002/04/2014 18:46:00ABKI 1000140
John02/04/2014 18:46:0002/04/2014 18:46:00ABKI 2000170
John02/04/2014 18:46:0002/04/2014 18:46:00ABKI 3000200
Mark02/04/2014 18:46:0002/04/2014 18:47:00ABKI 1000200
Mark02/04/2014 18:46:0002/04/2014 18:47:00ABKI 2000230

and so on...

Do you think you can help?
Thank you very much !

Here is the link 

Top Contributor Hyde's suggestion of using a script for what you want to accomplish is a good one ... however please also have a look at my following formula based solution