I'm trying to drag-copy some cells that are in the top row as 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 the right so that this pattern continues for all group names in column B.
It doesn't work. I thought selecting the first four cells (ID
Machinery
ID
Clothing
) and dragging them might help Google Spreadsheets recognize a pattern, but it didn't. I tried the same thing in 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 have to copy paste and edit for each entry?