Google Spreadsheet Post #2400
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Mar-18-2018
question by: Zachary Chandler
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/GlHJmCTU81Q;context-place=forum/docs
Getting more out of auto filling an equation?
Hi there! I'm trying to format some text, and I've set up what I thought was a simple enough pattern for the autofill to pick up on but sadly no dice. I've got a column of information that is in a certain order and I'm trying to format it into simple rows. What I've got right now looks like this
And I'm trying to make it look like this
I'm using the CONCATENATE() function to add the punctuation, and my formulas for the cells are
=CONCATENATE("""",B6,"""",",")
=CONCATENATE(B7,",")
=CONCATENATE(B8,",")
=CONCATENATE("""",B9,"""",",")
This is what I'm using from left to right, the next row has B10, B11, B12, and B13 respectively. I tried filling this row down and it didn't work as I had hoped, I then input it manually for three rows to see if the pattern would click (previous row# + 4)but the results I got were very hit and miss (currently auto filling another row gives B9, B11, B12, B13 which is the right range of data but starts in the wrong place).
How would I go about either getting autofill to just add 4 to the row entry relative to the cell above it? Or, what other functions could I use to describe the behaviour explicitly?
Thanks for your time!
P.S I'm in a computer class with homework that has some seriously tedious data entry aspects and while its taking me more time to figure out how to do it 'smarter' than doing it manually I'm looking at this as learning opportunity to automate future tedious tasks. I tried to google about this issue but didn't pull anything I could use.
No comments:
Post a Comment