The transpose tag has no usage guidance.

**0**

votes

**0**answers

32 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 ...

**4**

votes

**1**answer

60 views

### Taking an indirect reference in Excel and making it a direct reference

For many somewhat complicated reasons – it has to do with transposing columns and rows because of third party software limitations, etc. – I have had to use the INDIRECT function in order to make ...

**0**

votes

**0**answers

36 views

### Transpose 1 of 2 label columns

I have a table that has 2 label columns and then a series of data columns formatted as such. And I have nearly 20,000 rows, 900+ Accounts and 16 Quarters, so serious amounts of data. Not something I ...

**1**

vote

**1**answer

52 views

### 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:
...

**1**

vote

**0**answers

18 views

### transposing a row with formulae & values both in several cells to another sheet in same file Excel [duplicate]

Consider the data arranged as follows in my Sheet1. I want the fifth row to be transposed in the Sheet2.
When I reference the first item from B5 in Sheet2, and then drag the fill-handle(?) ...

**0**

votes

**2**answers

74 views

### Pasting from several rows into a single row every 6th cell

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
...

**0**

votes

**1**answer

35 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**

vote

**1**answer

1k 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 ...

**1**

vote

**1**answer

2k 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 ...

**2**

votes

**1**answer

1k 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 ...

**0**

votes

**3**answers

6k 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

452 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
...

**0**

votes

**2**answers

5k 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 ...