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.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,214,561
Messages
6,120,242
Members
448,951
Latest member
jennlynn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top