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
61
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
170
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
57
views
0
votes
2
answers
256
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
29
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
216
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
991
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
287
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
194
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
234
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