Sunday, April 24, 2016

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:

word13010000.18$1.54word3US0.69880
word22460000.34$3.07word2US0.44880
word31650000.16$1.36word1US0.64390
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:

word13010000.18$1.54word1US0.64390
word22460000.34$3.07word2US0.44880
word31650000.16$1.36word3US0.69880

Any help would be appreciated!