transpose data

[jsimha]

Dear Gurus,

can any one suggest how to transpose data below

Data I have in below format:
ABC A1
ABC B1
ABC C1
ABD A1
ABD B1
ABD C1

want to covert in to like below
ABC A1 B1 C1
ABD A1 B1 C1

please please help how to fix it. have lot of data to be formatted like this.

Regards,
Jay

[arlu1201]

Ensuring that your data starts in row 2, try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

[jsimha]

you rock.
I save this code forever, it saves lot of time for me.
it works well.