# Help moving data from rows to columns

#### PapaSmurfHUKD

##### New Member
Hi

Really stuck with this one - wondering if anyone can help

I've got a data sheet that looks a little something like this:

1 2 3 4 5........31
Mary Q1. a e i m q......
Q2. b f j n r......
Q3. c g k o s.....
Q4. d h l p t......

1 2 3 4 5........31
John Q1. a e i m q......
Q2. b f j n r......
Q3. c g k o s.....
Q4. d h l p t......

1 2 3 4 5........31
Jack Q1. a e i m q......
Q2. b f j n r......
Q3. c g k o s.....
Q4. d h l p t......

etc etc etc

...and i am looking to move the data into a Pivot Table. Now, from what little i know of Pivot Tables, the data needs to be in this format

1 Q1 Mary a
1 Q2 Mary b
1 Q3 Mary c
1 Q4 Mary d
2 Q1 Mary e
2 Q2 Mary f
2 Q3 Mary g
2 Q4 Mary h
3 Q1 Mary i
3 Q2 Mary j
3 Q3 Mary k
3 Q4 Mary l.........
1 Q1 John a
1 Q2 John b
1 Q3 John c
1 Q4 John d
2 Q1 John e
2 Q2 John f
2 Q3 John g
2 Q4 John h
3 Q1 John i
3 Q2 John j
3 Q3 John k
3 Q4 John l

as i want the pivot table to produce a graph showing trend movement in each question by day.

Any idea how to (other than cut and paste) i can get the data from one format to the other?

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

http://img593.imageshack.us/i/excelhelp.jpg/

if this helps any

where D2, D3, D4, D5 should equal H5, H6, H7, H8
and D6, D7, D8, D9 should equal I5, I6, I7, I8
and D10, D11, D12, D13 should equal J5, J6, J7, J8

etc etc

Last edited:

Replies
3
Views
65
Replies
1
Views
65
Replies
1
Views
300
Replies
6
Views
401
Replies
0
Views
272

1,211,530
Messages
6,102,374
Members
447,795
Latest member
siddharthvb

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back