request for help : pivot table or possible formulas
Hello!
thank you for seeing the thread.
may i ask for your help in my problem?
im trying to present the statements of those who "agreed" to certain persons.
i have to do this to about 4000 people agreeing to 1000 people, is there a faster way? im all out of options.
input:
input.PNG
expected output:
output.PNG
i appreciate all help! thank you in advance!
Last edited by earl_ama; 03-15-2017 at 09:23 PM. Reason: image upload
Attach a sample workbook. (Not a picture!)
Make sure there is just enough data to demonstrate your need. Include a BEFORE (original) sheet and an AFTER (required output) sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary. Remember, it should reflect original structure of your data.
Remember to desensitize the data.
Note:
- Please do not attach password protected workbooks/worksheets
- Please do not attach file(s) from exterior servers
- Please do not attach file(s) with enabled any Workbook Open/Autorun macros!
20 rows of data is enough (probably)
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If link is not from FORUM server you have to wait until someone will want to watch the file from an external server.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks