yogi_Custom Sort Data In Columns E2:H To match The Order Of Entries In Columns A2:A

Google Spreadsheet   Post  #2060

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-24-2016

question by: sc456a:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/N-xhnmvBLyE;context-place=forum/docs

Matching two sets of data by columns

Here's an example:

word1	301000	0.18	$1.54	word3	US	0.69	880
word2	246000	0.34	$3.07	word2	US	0.44	880
word3	165000	0.16	$1.36	word1	US	0.64	390

What I'd like to do is sort the right four columns to match the order found in the left four, based on the keywords matching. Word1 would then be at the top, followed by word2, etc, with the data in the far right three columns resorted as well, for an end result like so:

word1	301000	0.18	$1.54	word1	US	0.64	390
word2	246000	0.34	$3.07	word2	US	0.44	880
word3	165000	0.16	$1.36	word3	US	0.69	880

Any help would be appreciated!