**Question description:**

*This user has given permission to use the problem statement for this blog.*

Good morning. I would like to pull information from a spreadsheet into separate documents for each column. If you can imagine how forms work, I want it to do the opposite - take the information from a spreadsheet and create a page for each of the entries. I would like the first row on the original sheet to become the first column on each of the following pages, with the corresponding information from each row from the original document.

Solved by D. U. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
04/06/2018 - 03:18

Hello
Welcome to Gotit pro,
your problem will be highly answered
here.
May I ask how may I help you?

User
04/06/2018 - 03:18

I have a spreadsheet that I would like to have the data manipulated in.

Excelchat Expert
04/06/2018 - 03:19

ok, I am currently reading on your question now

User
04/06/2018 - 03:19

What I would like to do is to transpose all of the data, and have each row made into their own page with the first row on the original sheet as the first column on the new sheets

Excelchat Expert
04/06/2018 - 03:20

ok, could I have your data so we can easily figure it out the solution that you want

User
04/06/2018 - 03:21

I do not have access to the exact file at the moment unfortunately. but I think we can work this out still

Excelchat Expert
04/06/2018 - 03:22

oh ok,

User
04/06/2018 - 03:22

The sheet has about 10 or so columns, with about 50 rows of information

Excelchat Expert
04/06/2018 - 03:22

let just have sample

Excelchat Expert
04/06/2018 - 03:22

ok

User
04/06/2018 - 03:23

The first row is just a header, and I would like for that to be the first column on the other sheets

Excelchat Expert
04/06/2018 - 03:24

then each row, you want it to be the header of per sheet?

User
04/06/2018 - 03:24

I would like each of the next rows to be the second column on new pages

User
04/06/2018 - 03:24

yes

User
04/06/2018 - 03:24

but I would like the header to be a column and not a row

Excelchat Expert
04/06/2018 - 03:25

ok will check into tis

Excelchat Expert
04/06/2018 - 03:25

this*

Excelchat Expert
04/06/2018 - 03:25

just give me a minute to work on this

User
04/06/2018 - 03:25

sure

User
04/06/2018 - 03:32

essentially I would like to do the reverse of a form.

Excelchat Expert
04/06/2018 - 03:32

have you seen it now

Excelchat Expert
04/06/2018 - 03:32

the one I created?

User
04/06/2018 - 03:32

no

Excelchat Expert
04/06/2018 - 03:32

you are not seeing our spreadsheet?

User
04/06/2018 - 03:33

Im there now

Excelchat Expert
04/06/2018 - 03:33

ok :)

User
04/06/2018 - 03:34

yes

Excelchat Expert
04/06/2018 - 03:35

is it the out put that you want to show up?

User
04/06/2018 - 03:35

yes it is

Excelchat Expert
04/06/2018 - 03:35

great :)

User
04/06/2018 - 03:35

now how did we get there

Excelchat Expert
04/06/2018 - 03:35

we have just used the index() function

Excelchat Expert
04/06/2018 - 03:36

in order to get the value each row

Excelchat Expert
04/06/2018 - 03:37

like this one =index(range of data,# of row,# of column)

Excelchat Expert
04/06/2018 - 03:37

=index(Sheet1!A:D,1,1)

User
04/06/2018 - 03:37

ok, perfect

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*