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.