Convert table into panel format

[simonkay]

Hey everybody,

is there anyone who could help me out with the following? :

I have an excel table looking like:

Date 100 101 102
xx/yy A B A
xx/yy A B C
xx/yy B B B


I would like to have that table in panel format looking like (note: column names have been added):

another note: numbers belong to "Company_ID" and letters to "Rating"

Date Company_ID Rating
xx/yy 100 A
xx/yy 100 A
xx/yy 100 B
xx/yy 101 B
xx/yy 101 B
xx/yy 101 B
xx/yy 102 A
xx/yy 102 C
xx/yy 102 B


Thank you very much to anybody that tries to help me out on this!!!!!

Best regards,

Simon

[Pete_UK]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon or scroll down to Manage Attachments to open the upload window.

Pete

[Pepe Le Mokko]

Excel's PivotTable Wizard to the RESCUE!

1) Start the wizard -- Data/PivotTable & PivotChart Report...
If you have Excel Version 2007+ use alt+D P to activate the PT Wisard

2) Step 1 of 3 - Select Option Button: Multiple Consolidation Ranges -- [Next]

3) Step 2a of 3 - Select Option Button: I will create the page fields -- [Next]

4) Step 2b of 3 - With your cursor in the Range Textbox, select the data range on your sheet that you want to normalize -- [Add] -- [Next]

5) Step 3 of 3 - [Finish]

6) Drag the Row and Column buttons OFF the Layout -- [OK] -- [Finish]

7) Mysteriously, you are on another sheet that has a 4-cell pivot table. Double click the BOTTOM RIGHT CELL

8) Again, on another sheet -- This is you data normalized, or at least closer to it. You'll need to change headings at least.

Courtesy of Tek-Tips.com