Transposing data from row to columns (not the usual copy past and transpose function)

casco

New Member
Joined
Sep 21, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hi All

I'm having a data set that comprises of a number of entries which is translations in different languages. When the data is exported out of our ERP system it is sorted by language in a column B. I can get the different translations for each product to be beneath each other, for each product code ie Row 2 has English translation, Row t2 have German translation and so or for each product (simple filter to do this). However I would like to end up with the translation for each product in the columns ie product code in column A, English translation in column B, German translation in Column C and so on. Unfortunately the normal transpose functions cant do this so is there an add in or programming I can do to make this happen. We are talking about tens of thousands of lines.

This is how it comes out

Product codeLanguageDescription
1000-2000EnglishSmall Clear Insert
1000-2000GermanKleiner klarer Einsatz

I would like it to be presented as per below

Product CodeDescription Language EnglishDescription Language German
1000-2000Small Clear InsertKleiner klarer Einsatz


I'm using Excell 2010

Your help is as always appreciated

Best
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,127,685
Messages
5,626,293
Members
416,172
Latest member
lordposh

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
Top