I have a large 5 Column 5 (A to E). This file is 518K rows. Column D is Blank. What I need is a formula that would take the value in Column C and append 'Group 1' to it for first 1000 rows. Then append 'Group 2' for next 1000 rows etc... So if Column C was 'Test' then Column D would be 'Test Group 1' for first 1000 Rows and 'Test Group 2 for next 1000 rows. I don't want to manually do a concatenate. Somehow I need the logic to go by the row number.
I could also convert this to a TAB delimited text file and if a VB script could do it easier that's fine too. Just need 4th column to contain the result.