Convert Two dimentional table to single dimention

I have a two dimentional table that I want to be able to convert to single dimention records so I can import into database as records.

Sample two dimentional table
Description, Week1, Week2, Week 3,
Widget1, 200, 100, 150
Widget2, 75, 25, 30
Widget3, 10, 20, 30

I want to be able to convert above table into format as below

Widget1, week1, 200
Widget1, week2, 100
widget1, week3, 150
widget2, week1, 75
widget2, week2, 25
widget2, week3, 30
widget3, week1, 10
widget3, week2, 20
widget3, week3, 30

I do this each week with with approx, 40,000 records, (single dimention) copying and pasting is becoming a chore. Does anyone know a method to address this via functions, macros, formulas, etc. Number of rows and columns vary each time I repeat the exercise.

Appreciate any help.
Yves

Originally Posted by ychartra

I have a two dimentional table that I want to be able to convert to single dimention records so I can import into database as records.

Sample two dimentional table
Description, Week1, Week2, Week 3,
Widget1, 200, 100, 150
Widget2, 75, 25, 30
Widget3, 10, 20, 30

I want to be able to convert above table into format as below

Widget1, week1, 200
Widget1, week2, 100
widget1, week3, 150
widget2, week1, 75
widget2, week2, 25
widget2, week3, 30
widget3, week1, 10
widget3, week2, 20
widget3, week3, 30

I do this each week with with approx, 40,000 records, (single dimention) copying and pasting is becoming a chore. Does anyone know a method to address this via functions, macros, formulas, etc. Number of rows and columns vary each time I repeat the exercise.

Appreciate any help.
Yves

Hi,

a macro something like

Please Login or Register  to view this content.

should do the trick, remember to save your sheet before running the macro.

hth
---

If you're allergic to VBA you can also apply the technique found here : http://www.tek-tips.com/faqs.cfm?fid=5287
Don't really know why, but il works fantastic

Thanx Bryan it worked.