Turning Multiple Columns into one Column

Jtunner

Hi,

I have the following issue:

I have customers who buy goods.  But the data set list the columns as Customer Total Sales Coffee Tea Juice.  I would like to take the items and put them in one column and the amounts into another.  I have attached a before and after excel file.  Would love some help.  I know it is easy, but I am newbie who easily gets stumped!  Thank you!!!  JT

Transpose.xlsx

jasperlch

Hi @Jtunner,

You have actually got the name of the tool required right. All you need is a Transpose tool, with "Name" checked as Key Fields, and "Coffee", "Tea", "Juice" checked as Data Fields in its Configurations. 

Thanks,

Jasper