sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 1,010
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
My data are in random column so i need these data in sequence like A,B C D column
My data are in random column so i need these data in sequence like A,B C D column
| FS_CPL.xlsm | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |||
| 1 | LATE NIGHT W/SETH MYERS | MOTOR SPORTS | NBC5 NEWS AT 5PM | NBC5 NEWS AT 6PM | NBC5 NEWS AT 10PM | NBC5 NEWS AT 10PM SU | |||||||||||||
Delta EXShared (2) | |||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G1,V1,S1,P1,M1,J1 | G1 | =INDEX(INDIRECT("'"&$A$6&$B$6&"'!A1:IV100"),$B$1,G$2) |
