question610
New Member
- Joined
- Jul 3, 2017
- Messages
- 29
I have a spreadsheet that shows information about each office location, the different departments in that department and various attributes about that department. Using this information, i need to create a table for each office location with each department as a row. There will be 4 required columns which are universal information given for each department and one last column called comments, which all are the other remaining attributes.
First, I want to get the information in the right table format. This is the hardest and most important part.
Data:
[/IMG]
[/IMG]
[/IMG]
Desired Results:
I want the user to be able to choose what locations and within that location, what departments to include.
Ex: I want to know about Engineering, HR and Sales for New York (but not Accounting) and Sales and PR at Tokyo.
First, I want to get the information in the right table format. This is the hardest and most important part.
Data:
![1t626d.jpg](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttp%3A%2F%2Fi64.tinypic.com%2F1t626d.jpg&hash=b414470ec54be1f1027a4ca650057bb2)
![28i50t4.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttp%3A%2F%2Fi66.tinypic.com%2F28i50t4.png&hash=9e0e1b55fc4d83a63fc2b647c5cc2c7c)
![2duas2.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttp%3A%2F%2Fi66.tinypic.com%2F2duas2.png&hash=76857c99659115766cd700a340733cf1)
[/IMG]
Desired Results:
I want the user to be able to choose what locations and within that location, what departments to include.
Ex: I want to know about Engineering, HR and Sales for New York (but not Accounting) and Sales and PR at Tokyo.
![2qbdlhu.png](/board/proxy.php?image=http%3A%2F%2Fi67.tinypic.com%2F2qbdlhu.png&hash=7703189a9cf59c08ec5d1aff91dcd2d6)