gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 675
- Office Version
- 2019
- Platform
- Windows
Hello, Im looking to convert a Horizontal list to a Vertical list with new a column for each "Week" in list.
Here is the data that needs to be converted:
Each Column starts a new 'Week'.
The text order for each Column:
Column 1 = A1,A2,B1,B2,C1,C2,D1,D1,D2,etc
Column 2 = R1,R2,S1,S2,T1,T2,U1,U2,V1,V2,etc
Example of possible outcome:
thanks for your help!
Here is the data that needs to be converted:
NFL.xlsm | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | BW | BX | BY | BZ | CA | CB | CC | CD | CE | CF | CG | CH | CI | CJ | CK | CL | CM | CN | CO | CP | CQ | CR | CS | CT | CU | CV | CW | CX | CY | CZ | DA | DB | DC | DD | DE | DF | DG | DH | DI | DJ | DK | DL | DM | DN | DO | DP | DQ | DR | DS | DT | DU | DV | DW | DX | DY | DZ | EA | EB | EC | ED | EE | EF | EG | EH | EI | EJ | EK | EL | EM | EN | EO | EP | EQ | ER | ES | ET | EU | EV | EW | EX | EY | EZ | FA | FB | FC | FD | FE | FF | FG | FH | FI | FJ | FK | FL | FM | FN | FO | FP | FQ | FR | FS | FT | FU | FV | FW | FX | FY | FZ | GA | GB | GC | GD | GE | GF | GG | GH | GI | GJ | GK | GL | GM | GN | GO | GP | GQ | GR | GS | GT | GU | GV | GW | GX | GY | GZ | HA | HB | HC | HD | HE | HF | HG | HH | HI | HJ | HK | HL | HM | HN | HO | HP | HQ | HR | HS | HT | HU | HV | HW | HX | HY | HZ | IA | IB | IC | ID | IE | IF | IG | IH | II | IJ | IK | IL | IM | IN | IO | IP | IQ | IR | IS | IT | IU | IV | IW | IX | IY | IZ | JA | JB | JC | JD | JE | JF | JG | JH | JI | JJ | JK | JL | JM | |||
1 | Week | HOU | SEA | CLE | NYJ | OAK | CHI | IND | GB | MIA | PHI | LAC | TB | ARZ | DAL | PIT | TEN | Week | CIN | NYG | ATL | DET | MIN | BUF | SF | LAR | DEN | CAR | JAX | WAS | BAL | KC | NE | NO | Week | MIA | CHI | LAR | WAS | TEN | OAK | SF | CIN | HOU | NYJ | CAR | DET | TB | DAL | GB | KC | Week | DEN | ARZ | IND | JAX | CLE | NO | MIN | SEA | LAC | PIT | BAL | NYG | NE | BUF | PHI | ATL | Week | TB | CAR | CIN | JAX | OAK | DEN | ARZ | PHI | BUF | LAR | MIA | IND | NYG | MIN | LAC | Week | KC | CIN | DET | ATL | WAS | BAL | CLE | HOU | MIA | NYJ | GB | LAR | ARZ | Week | NYG | DET | PIT | NO | CLE | GB | LAC | CAR | BUF | DAL | SEA | KC | SF | TB | CHI | Week | ATL | NE | TEN | OAK | IND | MIN | NYJ | LAR | JAX | NO | SF | DAL | TB | Week | GB | DEN | SEA | BAL | HOU | CAR | DET | CHI | NYG | OAK | MIA | PIT | NO | NE | Week | IND | TB | HOU | WAS | JAX | PHI | CIN | BUF | DEN | NYJ | SEA | SF | BAL | MIN | Week | ARZ | TEN | DET | PHI | NE | GB | PIT | ATL | CIN | LAC | DAL | KC | LAR | Week | HOU | WAS | BAL | OAK | LAC | NYG | TEN | CLE | CAR | ARZ | MIA | NO | SF | KC | CHI | SEA | Week | DAL | NO | DET | IND | CIN | JAX | OAK | WAS | CLE | LAR | NYG | PHI | NE | DEN | BUF | Week | NE | DEN | HOU | DAL | GB | TEN | KC | ARZ | MIN | IND | NYJ | ATL | NO | WAS | PIT | BAL | Week | LAC | BUF | CAR | HOU | NYJ | DET | TB | JAX | NE | CHI | CLE | SEA | PHI | KC | SF | PIT | Week | MIN | SF | TB | MIA | DEN | CLE | NYG | CIN | CHI | ATL | IND | CAR | LAR | PHI | TEN | BUF | Week | MIA | NO | GB | BAL | PIT | MIN | TEN | JAX | LAC | NYJ | DAL | WAS | ATL | OAK | ARZ | SEA | ||
2 | 1 | KC | ATL | BAL | BUF | CAR | DET | JAX | MIN | NE | WAS | CIN | NO | SF | LAR | NYG | DEN | 2 | CLE | CHI | DAL | GB | IND | MIA | NYJ | PHI | PIT | TB | TEN | ARZ | HOU | LAC | SEA | OAK | 3 | JAX | ATL | BUF | CLE | MIN | NE | NYG | PHI | PIT | IND | LAC | ARZ | DEN | SEA | NO | BAL | 4 | NYJ | CAR | CHI | CIN | DAL | DET | HOU | MIA | TB | TEN | WAS | LAR | KC | OAK | SF | GB | 5 | CHI | ATL | BAL | HOU | KC | NE | NYJ | PIT | TEN | WAS | SF | CLE | DAL | SEA | NO | 6 | BUF | IND | JAX | MIN | NYG | PHI | PIT | TEN | DEN | LAC | TB | SF | DAL | 7 | PHI | ATL | BAL | CAR | CIN | HOU | MIA | NO | NYJ | WAS | ARZ | DEN | NE | OAK | LAR | 8 | CAR | BUF | CIN | CLE | DET | GB | KC | MIA | LAC | CHI | SEA | PHI | NYG | 9 | SF | ATL | BUF | IND | JAX | KC | MIN | TEN | WAS | LAC | ARZ | DAL | TB | NYJ | 10 | TEN | CAR | CLE | DET | GB | NYG | PIT | ARZ | OAK | MIA | LAR | NO | NE | CHI | 11 | SEA | BAL | CAR | CLE | HOU | IND | JAX | NO | WAS | DEN | MIN | OAK | TB | 12 | DET | DAL | PIT | ATL | BUF | CIN | IND | JAX | MIN | NE | NYJ | DEN | LAR | TB | GB | PHI | 13 | BAL | ATL | CHI | HOU | MIA | MIN | NYJ | PIT | TEN | ARZ | SEA | GB | LAC | KC | SF | 14 | LAR | CAR | CHI | CIN | DET | JAX | MIA | NYG | TB | OAK | SEA | LAC | PHI | SF | BUF | CLE | 15 | OAK | DEN | GB | IND | LAR | TEN | ATL | BAL | MIA | MIN | NYG | WAS | ARZ | NO | DAL | CIN | 16 | NO | ARZ | DET | OAK | LAC | NYJ | BAL | HOU | JAX | KC | PIT | WAS | SEA | DAL | GB | NE | 17 | BUF | CAR | CHI | CIN | CLE | DET | HOU | IND | KC | NE | NYG | PHI | TB | DEN | LAR | SF | ||
Raw |
Each Column starts a new 'Week'.
The text order for each Column:
Column 1 = A1,A2,B1,B2,C1,C2,D1,D1,D2,etc
Column 2 = R1,R2,S1,S2,T1,T2,U1,U2,V1,V2,etc
Example of possible outcome:
NFL.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Week | Week | Week | ||
2 | 1 | 2 | 3 | ||
3 | HOU | CIN | MIA | ||
4 | KC | CLE | JAX | ||
5 | SEA | NYG | CHI | ||
6 | ATL | CHI | ATL | ||
7 | CLE | ATL | LAR | ||
8 | BAL | DAL | BUF | ||
Sheet1 |
thanks for your help!