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.
Questions tagged [transpose]
50 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,817
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
- 168
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
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
- 4
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
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
- 185
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
- 415
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,748
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-.
- 743
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
1
vote
1 answer
How to transpos columns to rows + duplicate given cell + delete all cells of given value in Excel?
I have a large spreadsheet (679 rows x 243 columns) consisting of a series of product SKUs in the first column, and each subsequent column represents an accessory. Every SKU to which the given accessory is applicable has the accessory part number…
foolishgrunt
- 117
1
vote
1 answer
How to Loop cluster / ranges horizontal to vertical via vba
Newbie here and would like to get a loop working in Microsoft excel. Basically, to arrange clusters / ranges from horizontal to vertical. I have tried transpose function but have not been successful to get a code working and it seems most samples…
DongM
- 41
1
vote
1 answer
Excel 2019 Transpose: Transposing multiple columns Excel
I have an excel sheet with three columns: Country, Year and Fuel consumption per capita.
Dataset:
The country column has data for all worldwide countries. The year range for each country is from 1965 to 2021. I'm trying to transpose the data in…
Nitinn
- 13
- 2
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
- 8
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…
