Garetht2014
New Member
- Joined
- Oct 21, 2014
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Hi, Below is part of a table that I am trying to move data around on but really struggling as you can tell from this post lol. the Red text explains what I am trying to do. Hope someone can help. Thanks Gareth | I need this column (B) to stay in the same format as it is now, but need to match the name from this column (A) to the name in Column D and put the name from column C at the beginning of Column B's name like the example below which has the Column C name at the start of the Column B name. | ||
Example: SCIL P6 OLD TOWN N49 54.791 W6 17.962 (29U 693882 5532475) | |||
----------------------------------------------------------------------------- | |||
OLD TOWN N49 54.791 W6 17.962 (29U 693882 5532475) | SCIL P6 | OLD TOWN | |
AA Exch lc@1 | HIGH STREET | ||
----------------------------------------------------------------------------- | AA P10@1 | GLANDARE RD JCN BEECHWOOD AVE | |
THE PARADE ALL FAULTYS ARE FAULTY 21/9/94 WWSXM03 N49 54.877 W6 18.904 (29U 692750 5532594) | AA P11@1 | JCN GADLYS RD & HIRWAUN ROAD | |
AA P12@1 | O/S YNYSLWYD SCHOOL CARDIFF RD | ||
----------------------------------------------------------------------------- | AA P13@1 | S/O NO 12 BRYNMAIR RD | |
R/O THE STRAND N49 54.940 W6 18.697 (29U 692993 5532720) | AA P14@1 | JCTN FFORCHAMAN AND CWMNEOL ST | |
AA P15@1 | ROSE ROW ESTATE | ||
----------------------------------------------------------------------------- | AA P16@1 | S/O 18 CANAL RD | |
PARTING CARN N49 55.112 W6 18.025 (29U 693786 5533067) | AA P17@1 | O/S NO 2 WELL PLACE | |
AA P18@1 | JCN FOTHERGILL ST AND ABERNANT RD | ||
----------------------------------------------------------------------------- | AA P19@1 | JCN BEDFORD ST AND CARDIFF ROAD | |
ISLES OF SCILLY SCILLONIA N49 55.707 W6 18.184 (29U 693556 5534163) | AA P1@1 | CARDIFF ROAD/CWMAMAN ROAD | |
AA P20@1 | OPP BRYNAWEL MERTHYR RD LLWYDCOED | ||
----------------------------------------------------------------------------- | AA P21@1 | O/S 48 HARRIET ST TRECYNON | |
TELEGRAPH ROAD N49 55.709 W6 18.188 (29U 693550 5534166) | AA P22@1 | O/S 15 CEMETERY RD TRECYNON | |
AA P23@1 | GLOUSTER HSE DEAN ST | ||
----------------------------------------------------------------------------- | AA P24@1 | S/O CHURCH UNITY ST | |
TRESCO M.D.F. N49 57.412 W6 20.536 (29U 690631 5537221) | AA P25@1 | OPP 5 GRIFFITH ST | |
AA P26@1 | JCN LLWYD COED RD AND MERTHYR RD | ||
----------------------------------------------------------------------------- | AA P27@1 | MEIRION STREET | |
SENNEN N50 04.578 W5 41.212 (30U 307757 5550572) | AA P28@1 | (R'O 1 LAUREL CL)LABURNAM DRIVE. | |
AA P29@1 | MAESGWYN | ||
----------------------------------------------------------------------------- | AA P2@1 | MOUNT HILL ST JUNC 274/275 CARDIFF ROAD | |
A30 N50 04.582 W5 41.227 (30U 307740 5550581) | AA P30@1 | JCN KING STREET CWMDARE. | |
AA P32@1 | JCN GADLYS STREET AND DOWLAIS ST | ||
----------------------------------------------------------------------------- | AA P33@1 | S/O 81 GLANAMAN RD | |
SENNEN COVE N50 04.664 W5 42.127 (30U 306673 5550770) | AA P34@1 | S/O 11 STATION TCE | |
AA P35@1 | R/O 115 JUBILEE ROAD GODREAMAN | ||
AA P36@1 | R/O CHAPEL PLEASANT VIEW ST ABERAMAN | ||
AA P37@1 | JCN CARDIFF RD AND BEDDOE ST ABERAMAN | ||
AA P38@1 | JCN CARDIFF RD AND CURRIE ST | ||
AA P39@1 | O/S CARREERS OFFICE WI ND ST | ||
AA P3@1 | CARDIFF STREET JUNCTIO N CROSS STREET | ||
AA P41@1 | JCN DERWENT DRIVE AND LLANGORSE RD | ||
AA P42@1 | S/O BAKERS GARAGE | ||
AA P43@1 | ABERAMAN INDUSTRIAL ESTATE | ||
AA P44@1 | JNC. CANAL RD & TIMOTHY ROW | ||
AA P45@1 | OPP EXCH HIGH ST | ||
AA P46@1 | S/O A.T.E.YARD HIGH STREET | ||
AA P47@1 | JCN.WHITCOMBE ST & CANON STREET |