I would like to convert this table data:
record1 salesperson1 code1 percent1 code2 percent2 code3 percent3 record2 salesperson2 code1 percent1 code2 percent2 code3 percent3 record3 salesperson3 code1 percent1 code2 percent2 code3 percent3 record4 salesperson4 code1 percent1 code2 percent2 code3 percent3
Into this:
record1 salesperson1 code1 percent1 record2 salesperson1 code2 percent2 record3 salesperson1 code3 percent3 record4 salesperson2 code1 percent1 record5 salesperson2 code2 percent2 record6 salesperson2 code3 percent3 record7 salesperson3 code1 percent1 record8 salesperson3 code2 percent2 record9 salesperson3 code3 percent3 record10 salesperson4 code1 percent1 record11 salesperson4 code2 percent2 record12 salesperson4 code3 percent3
I would prefer to use a query that I can then manipulate with VBA code. Can someone help please?