Need to convert data into a "table"

[Cedartie]

Hello!

I currently have data in a spreadsheet in this format,

Column1 3-Dec 4-Dec 5-Dec
01 - Atlanta 48,441 73,800 66,340
02 - Hanover 30,190 30,185 21,386
04 - San Antonio 62,538 46,878 34,338
05 - Worcester 20,556 23,322 21,749
11 - Leesburg 58,914 51,388 55,698

I need to transform the data (IN EXCEL) into a generic table style such as

Branch Date Sales
01 - Atlanta 3-Dec 48,441
01 - Atlanta 4-Dec 73,800
01 - Atlanta 5-Dec 66,340
02 - Hanover 3-Dec 30,190
02 - Hanover 4-Dec 30,185
02 - Hanover 5-Dec 21,386

Is there a way to do this?

[martindwilson]

you could use a pivot table see attached