SOLVED
Turning Multiple Columns into one Column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Jtunner
7 - Meteor
‎04-24-2019
06:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2
jasperlch
12 - Quasar
‎04-24-2019
07:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎04-24-2019
07:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!!!!!