1
vote
0answers
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
2answers
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
1answer
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
1answer
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
3answers
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
1answer
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
2answers
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
2answers
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 ...