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.
49
questions
1
vote
1
answer
59
views
How to Loop cluster / ranges horizontal to vertical via vba [closed]
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 ...
- 41
0
votes
1
answer
153
views
How to use transpose unique filter function to make a comma separated list in a single cell?
I need help using transpose(unique(filter) to essentially filter only be unique ID's and then convert the record number column into a list. I did this before and I showed the final result, but I ...
- 1
0
votes
1
answer
56
views
0
votes
2
answers
244
views
Excel - how to convert table headers in rows to columns?
I have a table in this format:
Name
John
Age
19
Color
Green
Name
Jane
Age
22
Color
Blue
Name
Mike
Age
30
Color
Red
And I would like to convert it to this format:
Name
Age
Color
John
19
...
- 3
0
votes
1
answer
28
views
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 ...
- 3
0
votes
1
answer
215
views
transpose multiple different columns to rows
please have a look at the lists attached. how to transpose from A to B ?
0
votes
1
answer
29
views
Transposing database with combination data
how do I get from what I have to what I want in this scenario?
Thank you!
0
votes
1
answer
121
views
transposing a single column into multiple rows with a marker
I have a data in an excel sheet (also in text file and csv) looks like this:
;;
A
1
2
3
;;
B
1
2
;;
C
1
2
3
4
5
Each group has a marker ";;" , and there is a space after each group. The ...
0
votes
1
answer
3k
views
EXCEL - How to group multiple rows ("children") into columns linked to same "parent"?
I'm trying to build a mail listing for our school parents, and I am not sure how to do the formula in Excel.
I have a long list of children (name and class) and for each of them their parent (name and ...
- 1
1
vote
4
answers
948
views
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 ...
- 113
1
vote
1
answer
282
views
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 ...
2
votes
3
answers
192
views
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 vector
20,857
20,888
14,938
0,01
20,872
20,825
14,992
0,007
20,...
- 67
2
votes
4
answers
231
views
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?
- 23
0
votes
1
answer
37
views
Trying to transpose different groupings of dates under different categories so the column of info goes into a row with the dates organize
Row
A
1-2-2020
1-4-2022
B
1-8-2021
C
1-19-2025
1-2-1923
4-23-2026
3-2-2030
into
A
B
C
1-2-2020
1-8-2021
1-19-2025
1-4-2022
1-2-1923
4-23-2026
3-2-2030
- 1
0
votes
0
answers
32
views
Stack/transpose and duplicate values [duplicate]
I have a lot of data in a format I need to rearrange.
Current table: Rows of subjects with values, each column corresponding to a time point
I need each "subject" to be duplicated x times (...
- 1
1
vote
1
answer
91
views
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.
- 11
2
votes
2
answers
275
views
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 ...
- 157
1
vote
0
answers
57
views
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 ...
- 11
3
votes
2
answers
852
views
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?
- 168
0
votes
1
answer
351
views
Excel: from horizontal to vertical arrangement of rows
to whom it may concern,
I urgently need your expertise on how to flip the data as per below input into output data:
I know how the transpose works but it is tedious if we are dealing with hundreds ...
- 11
0
votes
1
answer
238
views
Transpose Excel and create new column based on the transposed header values
I have an excel file:
And I am trying to transpose the file and create a new column with values based on the header values. So, I want one column (number) to have all the numbers and the values m0,m1,...
- 133
0
votes
1
answer
201
views
Finding all values in one column for unique values in another column-Excel
I need to show each description as combined separate column which point to a unique code. Each code has multiple descriptions and they may be blank and I need to show the blanks
I need some kind of ...
- 1
0
votes
1
answer
4k
views
How To Transpose Every 3 values From One row To Multiple columns?
This can be potentially embarrassing but hey, its never too late to learn.
I am using Microsoft 2010.
I have the above mentioned row values in triplicates (scrambled control %) and I'll need to ...
- 111
0
votes
1
answer
130
views
Rearanging complex excel data
I have a complex set of data that I need to rearrange in excel.
The table looks something like this
+----+--------+--------+--------+--------+
| ID | Text A | Text B | Text C | Text D |
+----+-------...
- 133
1
vote
3
answers
95
views
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 ...
- 11
0
votes
3
answers
7k
views
How to add contents of multiple rows into one cell, grouping by a third row in Excel 2010
I'm trying to get multiple names from different rows into one cell in one row, but group it by a value in another column. I also need the list of names to have line breaks between them, not a comma ...
- 121
2
votes
1
answer
5k
views
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:
- 336
1
vote
4
answers
20k
views
How To Consolidate Multiple Rows Into a Column
Here is my situation. I need to take a list of 38k customer accounts and sort the information to a specific template that I can import to our new website. However the way the data is presented makes ...
- 11
1
vote
1
answer
2k
views
transposing large datasets with set structure using formula
I am trying to find a way of tranposing large datasets (the structure is shown below) in a certain way and wondering how to implement it in Excel using a formula as to avoid time-consuming and error ...
- 13
0
votes
1
answer
272
views
An Excel Transpose between 2 specific symbols
I'm trying to organize catalog records exported from a very outdated program my library is using to get it ready to import into the new catalog. The records come out like this:
~#[K11
title[Yada ...
- 1
0
votes
2
answers
2k
views
Excel group multiple columns and transpose
I have an Excel sheet full of companies, branches, company data and contacts.
I'm trying to group the data on the same company and branch city, then transpose, so that in each single column I have ...
- 101
0
votes
3
answers
216
views
Excel Spreadsheet Data Transform
I have data in a table that needs to be transformed into time-series row data.
At the moment my data is in the following columns and format:
GEOID, July, August, September, October, November, ...
- 103
0
votes
1
answer
1k
views
Excel - transposing certain cells in a row of data
I have an excel spreadsheet, similar to below, with sets of two rows which are identical (other than column 3 and 4). Some rows do not have an identical consecutive row (in this case row 3). For each ...
0
votes
1
answer
126
views
Changing rows into columns in Excel
I have a table that looks like this in Excel:
|firstname |Greg |
|secondname|Armstrong|
|firstname |Joe |
|secondname|Bloggs |
|firstname |Jane |
|secondname|Doe |
And I need to ...
-1
votes
2
answers
12k
views
Excel, How to extract records that are all in one column
How can I extract all the records stacked into a single column and rearrange into a 'normal' table with records in rows and fields in columns? Data is "vertical" because that was arrangement in .DOC ...
- 101
0
votes
1
answer
199
views
Non-Standard Transpose in Excel
I have a set of horizontal data in Excel that I need vertical. I tried the transpose formula, but when I copy the formula down the next line vertical it is not the following line.
What I need is all ...
1
vote
0
answers
175
views
Pivot table from multiple datasets with transpose required (Excel 2010)
I've read all the questions on pivots combining multiple datasets and have played around too and can't crack this one.
The data setup I have is (image included below):
Multiple worksheets each with ...
- 9
-3
votes
1
answer
481
views
Transpose text using sed
Please help me figure out how to solve this using sed.
Given the following text:
Kerala
4222 8129 8163 8164
Delhi
8502 8503 8504 ...
1
vote
2
answers
22k
views
In Excel how can I transpose multiple rows into a single column?
I have rows of data all of equal length, e.g. A1:A5, B1:B5, C1:C5, etc. I want to put these into a single column, e.g. D1:D5, D6:D10, D11:D15, etc. There are no headers or row identifiers.
I think ...
- 11
0
votes
0
answers
3k
views
How to transpose a named range in Excel 2013, using cell formulas (not VBA)
Similar to this question, I want to display the values of a named range (horizontal) in a vertical range.
If I have data a b d f which is named Letters (as a named range). I want to display this ...
- 306
1
vote
1
answer
428
views
Transposing data from single column list to multi-columns [duplicate]
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:
...
- 1,688
0
votes
2
answers
142
views
Pasting from several rows into a single row every 6th cell [duplicate]
I need to copy every 6 cells down horizontal to a new column
So that D3/E3/F3/G3/H3/I3 goes to J2/K2/L2/M2/N2/O2
And that D4/E4/F4/G4/H4/I4 goes to P2/Q2/R2/S2/T2/U2
And so on for sets of 20 rows
...
- 1
0
votes
1
answer
45
views
Transpose data by checking similar cell data
I have a Excel sheet like below..
Color Size Qty
Red L 182
Red M 223
Red S 155
Red XS 30
Blue L 700
Blue M 845
Blue S 665
Blue ...
- 1
1
vote
1
answer
3k
views
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 ...
- 743
2
votes
1
answer
6k
views
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 ...
- 171
4
votes
3
answers
8k
views
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 ...
- 6,789
0
votes
3
answers
28k
views
Move every 7 columns into new row in Excel [duplicate]
I have a very large data set in Excel; all of the outcome scores are in a single column. I need these scores to be separated into rows so that every set of 7 scores (i.e., scores 2-8, 9-16, etc) are ...
1
vote
1
answer
2k
views
Transpose unequal excel columns to rows [closed]
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
...
- 83
0
votes
2
answers
25k
views
How to divide the sum of cells by 7 and then transpose them in Excel
I need to take a vertical row of numbers in excel and add them all and divide by seven. I then need to transpose the result into 7 equal rows (one for each day of the week.)
I have tried the ...
user1702830