Hi,
I've a serie of data with this configuration:
Column A
STREET NAME
000000-U-0000
000000-U-0000
000000-U-0000
<empty cell>
OTHER STREET NAME
000000-U-0000
000000-U-0000
<empty cell>
AVENUE NAME
000000-U-0000
000000-U-0000
000000-U-0000
000000-U-0000
000000-U-0000
Is it possible to transpose the data under the "street name" to the Columns B, C, D (and so on)?
<tbody>
</tbody>
Regards.
I've a serie of data with this configuration:
Column A
STREET NAME
000000-U-0000
000000-U-0000
000000-U-0000
<empty cell>
OTHER STREET NAME
000000-U-0000
000000-U-0000
<empty cell>
AVENUE NAME
000000-U-0000
000000-U-0000
000000-U-0000
000000-U-0000
000000-U-0000
Is it possible to transpose the data under the "street name" to the Columns B, C, D (and so on)?
A | B | C | D | E | F |
STREET NAME | 000000-U-0000 | 000000-U-0000 | 000000-U-0000 | ||
OTHER STREET NAME | 000000-U-0000 | 000000-U-0000 | |||
AVENUE NAME | 000000-U-0000 | 000000-U-0000 | 000000-U-0000 | 000000-U-0000 | 000000-U-0000 |
<tbody>
</tbody>
Regards.