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     www.energyefficientbuild.com.   Feb-05-2014
post by Tidoko and question by Daniel  (https://productforums.google.com/forum/#!msg/docs/mLcdO0c2QEc/F7yNO9wdhVsJ)

Hi --Hyde,

Thank you for sharing your knowledge!

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

			ABKI 1000	ABKI 2000	ABKI 3000
John	02/04/2014 18:46:00	02/04/2014 18:46:00	140	170	200
Mark	02/04/2014 18:46:00	02/04/2014 18:47:00	200	230	250
Peter	02/04/2014 18:47:00	02/04/2014 18:47:00	40	50	60

and I need to convert the data in red to single rows combining its relative information.

So it would be something like:

John	02/04/2014 18:46:00	02/04/2014 18:46:00	ABKI 1000	140
John	02/04/2014 18:46:00	02/04/2014 18:46:00	ABKI 2000	170
John	02/04/2014 18:46:00	02/04/2014 18:46:00	ABKI 3000	200
Mark	02/04/2014 18:46:00	02/04/2014 18:47:00	ABKI 1000	200
Mark	02/04/2014 18:46:00	02/04/2014 18:47:00	ABKI 2000	230
...

and so on...

Do you think you can help?

Thank you very much !

Cheers

Daniel

Here is the link 

https://docs.google.com/spreadsheets/d/11EetOjUFqOMjvawKKQfztwjYefJtSXD8nQiX0d5Bm14/edit#gid=0

------------------------------------------------------------------------------------------------------------------------

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