Solved

Take a vertical list and reorganize to a horizontal list

Posted on 2012-03-23
2
185 Views
Last Modified: 2012-03-23
Hopefully my example will help explain my issue. I had terrific help in merging several workbooks into one worksheet. It worked perfect and now I need to tweak the list for two separate functions. The list in A:D list each Fire Zone (Zone) and then identifies which Engines respond to that zone. Perfect! But, now my boss asked me if I can list each Engine company and show what Fire Zones (Zones) they respond to (F:AF). Each Engine company responds to a variable number of zones with no one engine resonding to a max of 25 zones, but more likely around 10 zones)

I tried some index and match formulas along with a few if statements, but fell short. Not sure how to proceed.

Thanks for the help.
New-Merged-Workbook-ver-2-pat.xls
0
Comment
Question by:bvanscoy678
2 Comments
 
LVL 7

Accepted Solution

by:
leptonka earned 500 total points
ID: 37759095
Hi!
Attached a possible solution with array formulas.
I assumed that here is no duplicated E-values in the original Engine-rows.
Best regards,
Kris
New-Merged-Workbook-ver-2-pat-so.xls
0
 

Author Closing Comment

by:bvanscoy678
ID: 37759304
I am not even going to pretend to understand what you did with this!

Thanks for the help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now