Combining Two Sheets

[aaverett3]

Hi all,

I am posting because I am trying to combine two sheets that have very different formats. I have tried a couple of formats but none of them are very easy on the eyes. I was wondering if anyone has any suggestions for me.

I have attached the doc and it is the first two sheets that need to be combined (Building Type Analysis and Construction Cost). I am very open to organizing this in a new way so any ideas would be much appreciated!

*Also I apologize if I am not posting this in the correct spot*

Thanks!!

[BB1972]

Hi, it isn't clear (to me, at least) how you would like the two sheets combined - perhaps you could show or explain how the information on one tab relates to the other.

[aaverett3]

If you look at the "Combined Analysis" tab you can see one of my attempts to mesh the two together. My orginial post was vague but that because I am not exactly sure how I want them to be combined either. I just need all of the information from the two sheets to be condensed to one tab. The "Combined Analysis" tab works but it is difficult to understand. SO I am searching for a better way to organize them.