Sorry, did not explain my self. Please note that "," denotes a different column in Excel.
Have a data set that looks like below.
Sku,1/1/2008,2/1/2008,3/1/2008
10054,5,11,18
Need to convert to like below
SKU, Period, Sales
1004, 1/1/2008, 5
1004, 2/1/2008, 11
1004, 3/1/2008, 18
Obviously this is not a cut, copy transpose issue. Also, while my sample only has 4 columns my actual data is much more extensive. Any help would be appreciated.
Bookmarks