I'm trying to drag copy some cells, which are on top row for headers, they get their values from a VLOOKUP formula (Basicaly all group names are in column B and I want them as column headers). Before each cell there is another cell just containing string "ID".
What I want is to select first pair (ID and Machinery) and drag to right so that this pattern continues for all group names in column B.
It doesn't work. I thought having first 4 cells (ID Machinery ID Clothing) and drag them might help Google Spreadsheet to recognize pattern, but it didn't. I tried same thing on Excel and if fails there too.
Then I realized dragging right only changes column letters in formulae not row numbers (which makes sense).
Is it possible to change this behaviour? If not, any suggestions for me not to copy paste and edit for each entry.