#### Pellissier

##### New Member

- Joined
- Apr 12, 2012

- Messages
- 25

Account | code 2 | POA2 | code 3 | POA3 | code4 | POA4 | code5 | POA5 | code6 | POA6 | code7 | POA7 |

150112654 | 24490 | Y | 27240 | Y | 27620 | Y | 28750 | Y | 45890 | Y | 45890 | Y |

150121531 | 21130 | Y | 25000 | Y | 28590 | Y | 45500 | Y | 56989 | Y | 56989 | Y |

150126191 | 18500 | Y | 19850 | Y | ||||||||

150128114 | 33100 | Y | 41400 | Y | V4581 | 1 | V4620 | 1 |

<tbody>

</tbody><colgroup><col><col span="12"></colgroup>

(sorry paste runs account and code 2 columns together but they are separate in my file - Code 2 is 5 characters)

That I need to transpose (2 columns) so it looks like this:

Account | Code | POA |

150112654 | 24490 | Y |

150112654 | 27240 | Y |

150112654 | 27620 | Y |

150112654 | 28750 | Y |

150112654 | 45890 | Y |

150112654 | 45890 | Y |

150121531 | 21130 | Y |

150121531 | 25000 | Y |

150121531 | 28590 | Y |

150121531 | 45500 | Y |

150121531 | 56989 | Y |

150121531 | 56989 | Y |

150126191 | 18500 | Y |

150126191 | 19850 | Y |

150128114 | 33100 | Y |

150128114 | 41400 | Y |

150128114 | V4581 | 1 |

150128114 | V4620 | 1 |

<tbody>

</tbody><colgroup><col><col span="2"></colgroup>

Also all numbers are stored as text. Any help would be appreciated - I have a macro to go the other way - from one column to several but have not been able to reverse the process. |

<tbody>

</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>