Dear All,
I have a column of data that contains addresses as a list. Some of these span 5 lines, some span 6, 7 etc. All are broken by a blank row however.
<colgroup><col></colgroup><tbody>
</tbody>
I wish to transpose these so that I have a table type format rather than a list;
Company | Add 1 | etc.
Company A | Smith Road, The Square | etc.
Company B | Unit 11 | etc.
Aside from CTRL+C, Transpose for every address (list is about 6,000 rows) any idea how to do this?
All help appreciated!
Cheers.
I have a column of data that contains addresses as a list. Some of these span 5 lines, some span 6, 7 etc. All are broken by a blank row however.
Company A |
Smith Road , The Square |
Smith Street |
London |
W1 7EQ |
Company B |
Unit 11 |
Industrial Park Ltd. |
Downton Street |
Washington |
West Sussex |
RH20 4YB |
<colgroup><col></colgroup><tbody>
</tbody>
I wish to transpose these so that I have a table type format rather than a list;
Company | Add 1 | etc.
Company A | Smith Road, The Square | etc.
Company B | Unit 11 | etc.
Aside from CTRL+C, Transpose for every address (list is about 6,000 rows) any idea how to do this?
All help appreciated!
Cheers.