transpose excel data from multiple rows in columns

xlC

New Member
Joined
May 20, 2011
Messages
1
Hi,
I have this file like:

Column1 Column2 Column3
111 A11 011
111 A11 012
111 A11 013
----------------------------
111 B11 012
----------------------------
---------------------------
14213 XXX1 011
14213 XXX1 012
--------------------------

All I want is to transpose Column3 based on Column1 and Column2, as you see I have in Column1, and 2 hte same record repeating just because of Column3. In the end I want something like this:

Column1 Column2 New_ Column3 New_Column4.... New_Column "n" 111 A11 011 012 -----
111 B11 012
112 A11 014 020
---------------------------------------------------------------------
where "n" is the number of records in column3 for the same record in column1 and column2, I mean if I have the same record in column1, and column 2 let's say 5 times then I wil have 5 columns after column2 and the records should be from the cell(1:5).

Please is there anyone who can help me with this issue?
Thank you.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,118,407
Messages
5,571,924
Members
412,426
Latest member
DeficientOptimism
Top