Autofill Rows with sequential numbers

[ZZSCHMIDT]

Hi all,

I currently have an array that is 6 columns by 7 rows that is populated by referencing other workbooks and returning the sum of their values. For issue tracking revison etc... I would like to have the rows incrementally numbered (0,1,2... until it reaches number "X" which is a grand total in one of the fields.

This would happen for column 1 row 1 all the way through column 6 row 7 and fields with 0 as a total don't get a number or can have a 0 or blank.

Thanks,

Ex.
1 2 3 4 5 6 (rows)
1 3 x x x x x
2 x 7 x x x x
3 4
4
5
6
7

row numbering...
1
2
3 (skip col. 1 row 2)
1
2
3
4..... continues on till the end. I would like this to be something somewhat automatic to eliminate the redundancy of having to manually perform this task.

 

[venkat1926]

I assume that the row no. 1 to 7 is the column number and do not form the data.

your first row is
1 3 x x x etc

in the result why is it 1

row no. 2 is
2 X 7 X etc

in the result why is this 2

explain the logic

 

[ZZSCHMIDT]

Sorry about that.... I messed up my matrix.

col1 col2 col3 col4 col5 col6
row1 27 15 12 47 55 7
row2 5 9 10 11 33 0
row3 0 0 0 33 0 0
row4 5 22 11 5 9 0
row5 0 0 0 0 0 3
row6 1 0 4 0 1 0
row7 0 0 0 7 0 5

The data in the matrix is dynamic and won't be predictable (any one of them can have 55 or 0 depending on request totals). What I would like to happen is a list be generated that would incrementally increase the number in the rows of the new list for each field (always starting at 1).
Example: this would start with col1/row1 and end with col6/row7(leaving a blank if the request was 0)
1 (row1/col1 data)
2
.
.
27
1 (row2/col1 data)
2
3
4
5
(row3/col1 data)
1 (row4/col1 data)
2
3
4
5

Any help would be greatly appreciatted.