Tjyylli

Is there a problem with hiding "forgot password" until it's needed?

Greatest common substring

Do I need a multiple entry visa for a trip UK -> Sweden -> UK?

Is there a good way to store credentials outside of a password manager?

The plural of 'stomach"

Is this Spell Mimic feat balanced?

Products and sum of cubes in Fibonacci

At which point does a character regain all their Hit Dice?

What would happen if the UK refused to take part in EU Parliamentary elections?

How do I keep an essay about "feeling flat" from feeling flat?

Increase performance creating Mandelbrot set in python

What is the intuitive meaning of having a linear relationship between the logs of two variables?

Valid Badminton Score?

Time travel short story where a man arrives in the late 19th century in a time machine and then sends the machine back into the past

Trouble understanding overseas colleagues

What's a natural way to say that someone works somewhere (for a job)?

Why Were Madagascar and New Zealand Discovered So Late?

Is there any reason not to eat food that's been dropped on the surface of the moon?

Implement the Thanos sorting algorithm

Is there any easy technique written in Bhagavad GITA to control lust?

voltage of sounds of mp3files

How to be diplomatic in refusing to write code that breaches the privacy of our users

Curses work by shouting - How to avoid collateral damage?

Is HostGator storing my password in plaintext?

In Google Sheets, is there a way to autofill cells with a formula targeting cells horizontally (in rows) while autofilling vertically (in columns)?

0

Example Image

In the above image fields are populated as follow:

• A1 is empty/not important


• B1 = animal


• C1 = dog


• D1 = male


• E1 = animal


• F1 = cat


• G1 = male


• H1= insect


• I1 = ladybug


• J1 = unknown

What I wish to achieve is that column A should be equal to the name of the creatures in row 1.
For example, A2 should equal "dog", A3 should equal "cat", A4 should equal "ladybug", etc. etc.
The name of the creature will always be offset by 3 cells in the row.
I require them listed without empty rows beneath each other in column A.
I cannot delete rows at any time, therefore I need the formula to do the work for me.

Currently, If in A2 and A3 I point respectively to C1 and F1, and I attempt to click and drag the formula down column A, Sheets (as well as Excel) has no idea what my intentions are, which results in the next cell pointing to column C and the first empty row number I drag it onto, and then repeats that cycle all the way down.

I have attempted the OFFSET function, however it suffers from the same ailment of populating "in the wrong direction" and one at a time.
My last resort would be to create an indirect column with the correct pointers, but this is not favorable.
While I would like to stay away from Macros if at all possible, I will consider it a second-to-last resort if there truly is no other way.

Any ideas greatly appreciated.

microsoft-excel worksheet-function google-spreadsheets

share

asked 44 secs ago

phLOxphLOx

61

add a comment | 

0

Example Image

In the above image fields are populated as follow:

• A1 is empty/not important


• B1 = animal


• C1 = dog


• D1 = male


• E1 = animal


• F1 = cat


• G1 = male


• H1= insect


• I1 = ladybug


• J1 = unknown

What I wish to achieve is that column A should be equal to the name of the creatures in row 1.
For example, A2 should equal "dog", A3 should equal "cat", A4 should equal "ladybug", etc. etc.
The name of the creature will always be offset by 3 cells in the row.
I require them listed without empty rows beneath each other in column A.
I cannot delete rows at any time, therefore I need the formula to do the work for me.

Currently, If in A2 and A3 I point respectively to C1 and F1, and I attempt to click and drag the formula down column A, Sheets (as well as Excel) has no idea what my intentions are, which results in the next cell pointing to column C and the first empty row number I drag it onto, and then repeats that cycle all the way down.

I have attempted the OFFSET function, however it suffers from the same ailment of populating "in the wrong direction" and one at a time.
My last resort would be to create an indirect column with the correct pointers, but this is not favorable.
While I would like to stay away from Macros if at all possible, I will consider it a second-to-last resort if there truly is no other way.

Any ideas greatly appreciated.

microsoft-excel worksheet-function google-spreadsheets

share

asked 44 secs ago

phLOxphLOx

61

add a comment | 

Example Image

In the above image fields are populated as follow:

• A1 is empty/not important


• B1 = animal


• C1 = dog


• D1 = male


• E1 = animal


• F1 = cat


• G1 = male


• H1= insect


• I1 = ladybug


• J1 = unknown

What I wish to achieve is that column A should be equal to the name of the creatures in row 1.
For example, A2 should equal "dog", A3 should equal "cat", A4 should equal "ladybug", etc. etc.
The name of the creature will always be offset by 3 cells in the row.
I require them listed without empty rows beneath each other in column A.
I cannot delete rows at any time, therefore I need the formula to do the work for me.

Currently, If in A2 and A3 I point respectively to C1 and F1, and I attempt to click and drag the formula down column A, Sheets (as well as Excel) has no idea what my intentions are, which results in the next cell pointing to column C and the first empty row number I drag it onto, and then repeats that cycle all the way down.

I have attempted the OFFSET function, however it suffers from the same ailment of populating "in the wrong direction" and one at a time.
My last resort would be to create an indirect column with the correct pointers, but this is not favorable.
While I would like to stay away from Macros if at all possible, I will consider it a second-to-last resort if there truly is no other way.

Any ideas greatly appreciated.

microsoft-excel worksheet-function google-spreadsheets

share

asked 44 secs ago

phLOxphLOx

61

share

asked 44 secs ago

phLOxphLOx

61

share

asked 44 secs ago

phLOxphLOx

61

asked 44 secs ago

phLOxphLOx

61

asked 44 secs ago

phLOxphLOx

61