Super User Stack Exchange
Super User Stack Exchange

Questions tagged [transpose]

This tag should be used for questions regarding transposing data from one structure to another structure by changing position. If your question regards transposing with pivot tables, use pivot-table instead.

46 questions
4
votes
3 answers

Transpose table in Word

Is there a way to transpose (swap rows and columns) in post-ribbon Microsoft Word (currently using 2013)? For example, in this table, I want the top headings to go on the left (én, te, etc), and the left headings (van, megy, jön) go to the top…
Jay Wick
  • 6,759
  • 5
  • 49
  • 68
3
votes
2 answers

Partially transpose data which pasted as a single column

When I paste data from certain applications, it ends up as: A B C D E F G H I J K L But it's supposed to be: A B C D E F G H I J K L Is there an easy way to restructure?
zeroimpl
  • 148
  • 3
2
votes
1 answer

Excel - Finding all values in one column for unique values in another column

I have an Excel table that looks like this: Code | Description ------------------------- A | Desc1 A | Desc2 B | Desc3 C | Desc4 C | Desc5 C | Desc6 ... I need to find all the Descriptions for each unique Code. For example I want…
Brian
  • 171
  • 1
  • 3
  • 4
2
votes
3 answers

Excel - Divide One Column Vector Into Several Line Vectors

I am currently struggling to find out how a long column vector in excel can be divided into several line vectors. E.g. % one long column…
Timon
  • 67
  • 3
2
votes
4 answers

Transposed counts for many columns

The input: I have to get the count of the number of '1' and '0' in each column like this: Is there any way in Excel/macro to do this?
Vishnu
  • 23
  • 2
2
votes
2 answers

Unpivot/Transpose columns (without blanks)

I have an asset hierarchy table in Excel: For testing purposes, the table can be copied/pasted into Excel by using the text below: Hint: Copy the text from the Stack Overflow edit mode--instead of copying from the preview mode (the text from edit…
User1974
  • 137
  • 1
  • 18
2
votes
1 answer

MS office 2016 excel paste values with transpose

Is it possible to make this paste option (paste only values with transpose at the same time). As it shown on the schreenshot: and having one button for this option in drop-down menu here:
XuMuK
  • 300
  • 4
  • 15
1
vote
1 answer

Transposing data from single column list to multi-columns

I have an Excel spreadsheet which is tens of thousands of entries long but it's not organized. All the data is in a single column with each entry taking up 3 rows followed by a space. For example: Entry 1 Name Entry 1 Address Entry 1 Phone Entry 2…
davidcondrey
  • 1,628
  • 1
  • 22
  • 27
1
vote
1 answer

How can I transpose and group data in Excel 2010?

I don't think I'm phrasing the question correctly so I'd be pleased if someone could edit it to something sensible! I'm using Excel 2010 and I have a set of data like this: Art 12 Bob 15 Bob 18 Kev 16 Kev 13 Kev 14 Kev 20 Deb 12 Deb 21 I want to…
G-.
  • 753
  • 6
  • 12
  • 24
1
vote
1 answer

Transpose unequal excel columns to rows

I have received an Excel table with different number of items per category: Category A Category B Category C 22 11 1 34 15 6 55 4 18 33 36 I'd like to turn this into: Category …
Dan
  • 83
  • 3
  • 8
1
vote
4 answers

Transpose cells on another tab and link back to original cells

I have a table I need to have in both the original and transposed views. However, I need to be able to update both sheets from ONE place. How can I duplicate transposed cells to a second sheet with their values linked to the first…
AndrewRalon
  • 113
  • 7
1
vote
1 answer

Convert or transpose excel report (horizontal) to tabular (vertical) format for importing

Have been trying to find a solution so i can import this data into my ERP We get the report in a horizontal or report format (on the left) and manually enter into our system. If we can convert into a vertical format (on the right) we can import it…
Matthew Lazarus
  • 11
  • 2
1
vote
1 answer

I need help performing a complicated transpose

I have a list of items in a column, i need to transpose them to horizontal. I need a1 in b1 and a2 in c1 and a3 in d1, then a4 in b2 and a5 in c2 and a6 in d2 and so forth.
Chris C
  • 11
  • 1
1
vote
0 answers

Restructuring complicated excel sheet to standard rows

I have an excel sheet that has several thousand products on it. Each product consists of three columns of data with variable number of rows. This is how it currently looks like This is what I need to make it into Manufacturer changes every 10-50…
Hurme
  • 11
  • 1
1
vote
3 answers

Manipulate data in Excel to order results per a certain column

I want to make the information in some columns (but not all) displaying in rows, please see below an example. This is what I have (unfortunately this doesn't allow extra spaces so everything is unaligned, please try to imagine all aligned): …
Ricardo C.B.
  • 11
  • 1
1
2 3 4