Excel - IF Function Problem - Expert Solution

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
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
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
Excelchat Expert 04/06/2018 - 03:25
just give me a minute to work on this
User 04/06/2018 - 03:25
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
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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc