The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
24 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
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
58 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
1answer
34 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
1answer
903 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
1k 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
1answer
984 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
3answers
3k 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
335 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
2k 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 ...