Hi, I want a column which starts with the first value on A1 e.g. 3. The following data down the column should be:
A1*1 A1*2 A1*3 A1*4 .... and so on.
When I select three terms and drag the black box, bottom right, down. It continues:
A3*1 A3*2 A3*3 A6*1 A6*2 .... etc.