Home » Forums » Open Source Learning Center » Question and Answer

Excel Transpose

Submitted by Monica on 21 October, 2013 - 16:42

Hi there,

I have a row with numerous columns:

Supplier Number, Name, Address, Contact1 name, Contact1 email , contact2 name, Contact 2 email add, Contact 3 name , Contact 3 Email Address

I need to transpose , where column 1 and 2 get repeated for every row, and each contact name with it asocaited Email has it's own row.

Any ideas ?

Thanks
Monica

‹ newbie question: identifying returning queries in a speadsheet I need help to design a VBA code ›
»
Almir's picture

Please, post a file with example data

Submitted by Almir on 14 February, 2014 - 17:35.

Please, post a file with example data, showing both current and desired layout.

»