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.
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.