For example,
ROW1 Tom 1 2 3 4 5 6
into
ROW1 Tom 1
ROW2 2
ROW3 3
ROW4 4
ROW5 5
ROW6 6
Since there are thousand of such kind of records, I would like to make it in anautomatic way by macro or VBA.
Thank you for your help.
更新1:
Thanks 新田美香, I have to try to record a macro for it, but it seems too complicated for amendment for fitting my task. Any suggestion on the how to write VBA on the issue? Thanks.