# Tagged Questions

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

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

**1**

vote

**1**answer

584 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

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

**0**

votes

**3**answers

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

267 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

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

**0**

votes

**2**answers

2k views

### Excel Line Graph with columns and rows transposed

My team has a spreadsheet in which we track counts of incidents of known issues from week to week. The sheet is organized with the issue title in column A and "Week 1" through "Week [N]" in columns B ...