google sheets
I copy code from an editor into a Google Spreadsheets cell. Unfortunately, it left-aligns the code making it hard to read.
However, when I double-click on it to edit it, the tabs are still there (second image) so I know it didn't delete the tabs, just collapsed them.
How do I get Google Spreadsheets to also display the code showing the tabs as tabs instead of collapsing them?
As explained here when drag copy formula horizontally incrementation happens with anything related to columns. Nothing happens with rows. In order to get an increasing number one can use COLUMN() function in this scenario.
We get row number of original list with a calculation involving COLUMN() function, but then we have to create a string defining our original list's range and get the value in that cell. This is done by INDIRECT() function. (VLOOKUP method not good)
=INDIRECT("$B"&COLUMN()/2)
Now selecting ID and Machinery and dragging right fills all consecutive columns as desired.
Another alternative:
=INDEX($B:$B;COLUMN()/2)
Sheets needs to be "tricked" into recalculation, which may be achieved for all formulae by replacing = with =:
Best Answer
This is not possible at the moment, but a feature request has been made. See this link for more information.