help designing a huge table

[bos1234]

Hi
I have this huge table that I am trying to make more a bit more cleaner.
I have attached/upload an image of the table. As you can see, Site A and Site B cells are huge because I have merged and centered. These two locations are repeated for each vendor, hence I did not want to keep repeating the same information.

As a result, I have these huge cells to the left. Any other way of organizing this information?

http://s2.postimg.org/4xbn511yx/image.png

[Kyle123]

Hi,

The problem is that you're creating a relationship Vendor to details that isn't easy to logically mapped in excel without repeating the vendor for every line of details. This structure is the core of databases (as opposed to spreadsheets) which are designed to handle these types of relationships, where they're referred to a a one to many relationship - one vendor to many details. In a database, you'd at the most simple level have 2 tables, a vendor table and a details table. The vendor table would just have each vendor listed once. Your details table would hold all the other data and each row would hold a reference to a vendor.

So in short for this to be manageable id use a database, but if you do want to keep it in excel, removing the merged cells and repeating for each line will make things easier to work with.

[bos1234]

Very interesting. Thank you for your help

[Kyle123]

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).