Transfering Data between Excel Tables of different setup

[mel_d]

I have a table that I need transferred into another format. All the information stays the same but it will have a different logic: rows become columns and vice versa. This is a table with a LOT of data so I can't do it manually. What is the easiest way to do this? I'm thinking a formula that will reference the original table and transfer the appropriate cells into the new table. I just can't seem to figure out a good way to do this since I have multiple parameters. ANY help is appreciated!!! Picture of the two tables attached - I'm trying to transfer the yellow dates of the original table into the respective yellow fields of the new table.

 

[alansidman]

Can you post a sample to Box.net or Dropbox.com or a similar site so that the data solution can be tested. It will make it easier than trying to recreate your scenario.

 

[sandy666]

Original range is not a table. This is a range.
Table doesn't allow merged cells and multi headers
Normalize this range to be a Table.

post a link to shared example excel file with source data and expected result. use GoogleDrive, OneDrive or any similar.