Thread: Table transformation

I have two questions regarding tables in Excel. The first question is how to convert a row into a column; I want to switch one column with a row, while keeping one column as a column.
The second question is whether it is possible to remove an unnecessary text string at the end of a field.

I have explained it in brief in the attached Excel-file.

Thank you very much.

Edit: It is not possible to use pivot tables in this case.

Re Q1 - I personally have no idea w/out a pivot table.

Re Q2 - Does it always have something unique (like your space+hyphen) in the middle? If so then you could use a formula like: =MID(A25,1,FIND(" -",A25)-1)

Thank you for your reply.

Maybe it is still possible to do it with pivot, I have attached a new file that maybe explains it better. I don't manage it with pivot.

For Q2: It always has something unique at the end or in the middle.

Ah, you're right. Pivot would be burdensome at best.

Let me think on a macro. It can be done using paste/transpose, but need to think thru the steps to split the companies from each other (and make it so it will work in future years and not just the current exact number of columns).