P
please respondhere
I've got an Excel worksheet with several columns of data. I want to randomly
shuffle all of the row data and then overwrite column A with sequential
numbers down the column, 1...X, where X is the last row. Any ideas?
Example:
1 B C D
2 G K L
3 D K C
might become
2 G K L
1 B C D
3 D K C
and then with column A renumbered, look like:
1 G K L
2 B C D
3 D K C
I don't know much about Excel at all. How can I develop such a thing.
Furthermore, can this also be done via a command line?
Thanks.
shuffle all of the row data and then overwrite column A with sequential
numbers down the column, 1...X, where X is the last row. Any ideas?
Example:
1 B C D
2 G K L
3 D K C
might become
2 G K L
1 B C D
3 D K C
and then with column A renumbered, look like:
1 G K L
2 B C D
3 D K C
I don't know much about Excel at all. How can I develop such a thing.
Furthermore, can this also be done via a command line?
Thanks.