I have a spreadsheet with the following columns:
The list above goes for about 18k rows. How do I take this data and put it into the following format on a separate tab:
3 | Corn Belt Wireless, Inc. | 9-Dec | 220 |
3 | Corn Belt Wireless, Inc. | 10-Jan | 220 |
3 | Corn Belt Wireless, Inc. | 10-Feb | 220 |
3 | Corn Belt Wireless, Inc. | 10-Mar | 220 |
3 | Corn Belt Wireless, Inc. | 10-Apr | 290 |
3 | Corn Belt Wireless, Inc. | 10-May | 290 |
3 | Corn Belt Wireless, Inc. | 10-Jun | 290 |
3 | Corn Belt Wireless, Inc. | 10-Jul | 410 |
3 | Corn Belt Wireless, Inc. | 10-Aug | 360 |
3 | Corn Belt Wireless, Inc. | 10-Sep | 360 |
3 | Corn Belt Wireless, Inc. | 10-Oct | 460 |
3 | Corn Belt Wireless, Inc. | 10-Nov | 430 |
3 | Corn Belt Wireless, Inc. | 10-Dec | 460 |
3 | Corn Belt Wireless, Inc. | 11-Jan | 460 |
3 | Corn Belt Wireless, Inc. | 11-Feb | 460 |
3 | Corn Belt Wireless, Inc. | 11-Mar | 680 |
3 | Corn Belt Wireless, Inc. | 11-Apr | 460 |
3 | Corn Belt Wireless, Inc. | 11-May | 460 |
3 | Corn Belt Wireless, Inc. | 11-Jun | 510 |
3 | Corn Belt Wireless, Inc. | 11-Jul | 530 |
3 | Corn Belt Wireless, Inc. | 11-Aug | 530 |
3 | Corn Belt Wireless, Inc. | 11-Sep | 530 |
3 | Corn Belt Wireless, Inc. | 11-Oct | 530 |
3 | Corn Belt Wireless, Inc. | 11-Nov | 530 |
3 | Corn Belt Wireless, Inc. | 11-Dec | 580 |
3 | Corn Belt Wireless, Inc. | 12-Jan | 580 |
3 | Corn Belt Wireless, Inc. | 12-Feb | 580 |
3 | Corn Belt Wireless, Inc. | 12-Mar | 630 |
3 | Corn Belt Wireless, Inc. | 12-Apr | 630 |
3 | Corn Belt Wireless, Inc. | 12-May | 630 |
3 | Corn Belt Wireless, Inc. | 12-Jun | 630 |
3 | Corn Belt Wireless, Inc. | 12-Jul | 630 |
3 | Corn Belt Wireless, Inc. | 12-Aug | 630 |
3 | Corn Belt Wireless, Inc. | 12-Sep | 630 |
3 | Corn Belt Wireless, Inc. | 12-Oct | 630 |
3 | Corn Belt Wireless, Inc. | 12-Nov | 630 |
8 | DMCI Broadband LLC | 9-Dec | 760 |
8 | DMCI Broadband LLC | 10-Jan | 780 |
8 | DMCI Broadband LLC | 10-Feb | 780 |
8 | DMCI Broadband LLC | 10-Mar | 820 |
8 | DMCI Broadband LLC | 10-Apr | 820 |
8 | DMCI Broadband LLC | 10-May | 860 |
8 | DMCI Broadband LLC | 10-Jun | 900 |
8 | DMCI Broadband LLC | 10-Jul | 900 |
8 | DMCI Broadband LLC | 10-Aug | 940 |
8 | DMCI Broadband LLC | 10-Sep | 940 |
8 | DMCI Broadband LLC | 10-Oct | 940 |
The list above goes for about 18k rows. How do I take this data and put it into the following format on a separate tab:
Customer Number | Customer Name | 9-Dec | 10-Jan | 10-Feb | 10-Mar | 10-Apr | 10-May | 10-Jun | 10-Jul | 10-Aug | 10-Sep | 10-Oct | 10-Nov | 10-Dec | 11-Jan | 11-Feb | 11-Mar | 11-Apr | 11-May | 11-Jun | 11-Jul | 11-Aug | 11-Sep | 11-Oct | 11-Nov | 11-Dec | 12-Jan | 12-Feb | 12-Mar | 12-Apr | 12-May | 12-Jun | 12-Jul | 12-Aug | 12-Sep | 12-Oct | 12-Nov | 12-Dec | 13-Jan | 13-Feb | 13-Mar | 13-Apr | 13-May | 13-Jun | 13-Jul | 13-Aug | 13-Sep | 13-Oct | 13-Nov | 13-Dec | 14-Jan | 14-Feb | 14-Mar | 14-Apr | 14-May | 14-Jun | 14-Jul | 14-Aug | 14-Sep | 14-Oct | 14-Nov | 14-Dec | 15-Jan | 15-Feb | 15-Mar | 15-Apr | 15-May | 15-Jun | 15-Jul | 15-Aug | 15-Sep | 15-Oct | 15-Nov | 15-Dec | 16-Jan | 16-Feb | 16-Mar | 16-Apr | 16-May | 16-Jun | 16-Jul | 16-Aug | 16-Sep | 16-Oct | 16-Nov | 16-Dec | 17-Jan | 17-Feb | 17-Mar | 17-Apr | 17-May | 17-Jun | 17-Jul | 17-Aug | 17-Sep | 17-Oct | 17-Nov | 17-Dec |
3 | Corn Belt Wireless, Inc. |