Sunday, February 15, 2015

yogi_Create A Column Of Entries Consisting Of Set Of Entries From Two Columns And A Specified String

             Google Spreadsheet   Post  #1894
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-15-2015
post by  drmetacognate:
[Spreadsheet Challenge] - How to combine two columns of data and a symbol evenly over one
The document linked below is open for anyone to edit. I've locked down the first tab, just make a copy of it and name it "HelperX". The green cell is where the function goes. Column A is what it should look like. I color coded the data to hopefully make it easier to understand. The types of values are very important (one column will be plan text, one will be alphanumeric, and the third is a repeating text string that includes a % symbol. Who's up for the challenge?! :)

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