I need help to change a report format as per the tow tables below ie from Table A to Table B for about 25k records. What kind of queries can I use?
TABLE ATABLE BWeekChannel codeChannel_NameAddressE1085TE1105TE1055E1225C3010Channel codeChannel_NameAddressModel48495048ENU45TOPCLASSG 91 RAILWAYLINE ENUGU22121ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE1085T21348ENU11UPSON COMMUNICATION1 CHIME AVENUE21125ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE1105T22548ENU44VILLA COMM61 OGUI ROAD ENUGU11007ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE105515848ENU55WIRELESS OPTION31 ZIKS AVENUE12000ENU45TOPCLASSG 91 RAILWAYLINE ENUGUE122523548ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKET20512ENU45TOPCLASSG 91 RAILWAYLINE ENUGUC301014749ENU45TOPCLASSG 91 RAILWAYLINE ENUGU12534ENU11UPSON COMMUNICATION1 CHIME AVENUEE1085T26249ENU11UPSON COMMUNICATION1 CHIME AVENUE65892ENU11UPSON COMMUNICATION1 CHIME AVENUEE1105T15249ENU44VILLA COMM61 OGUI ROAD ENUGU54565ENU11UPSON COMMUNICATION1 CHIME AVENUEE105518549ENU55WIRELESS OPTION31 ZIKS AVENUE18823ENU11UPSON COMMUNICATION1 CHIME AVENUEE122529449ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKET25723ENU11UPSON COMMUNICATION1 CHIME AVENUEC301052550ENU45TOPCLASSG 91 RAILWAYLINE ENUGU35857ENU44VILLA COMM61 OGUI ROAD ENUGUE1085T15850ENU11UPSON COMMUNICATION1 CHIME AVENUE22545ENU44VILLA COMM61 OGUI ROAD ENUGUE1105T14550ENU44VILLA COMM61 OGUI ROAD ENUGU85233ENU44VILLA COMM61 OGUI ROAD ENUGUE105505250ENU55WIRELESS OPTION31 ZIKS AVENUE52030ENU44VILLA COMM61 OGUI ROAD ENUGUE122506350ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKET95513ENU44VILLA COMM61 OGUI ROAD ENUGUC3010753ENU55WIRELESS OPTION31 ZIKS AVENUEE1085T115ENU55WIRELESS OPTION31 ZIKS AVENUEE1105T282ENU55WIRELESS OPTION31 ZIKS AVENUEE1055080ENU55WIRELESS OPTION31 ZIKS AVENUEE1225023ENU55WIRELESS OPTION31 ZIKS AVENUEC3010030ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1085T229ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1105T055ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1055575ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETE1225121ENU16WISDOM COMMUNICATION12 NEW HAVEN MARKETC3010233