Hello Guys,
Quick question... is there a way to turn a 3 column list like:
Red Apple 20
Red Berry 40
Red Banana 80
Blue Apple 30
Blue Berry 30
Blue Banana 40
Green Apple 40
Green Berry 30
Green Banana 30
into something like this
Red Blue GreenApple
Berry
Banana
With the corresponding data filled in
In order to make charts easier?
tnick771, Good afternoon.
You can have what you want using:
a) FUNCTIONS Formulas
b) VBA CODE
c) Pivot Table
I did an example for you using FUNCTIONS FORMULAS.
11-08-2014_Data_Table_Example.xlsx
Is it what you want?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Please see attached file with formulas.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Alkey, Good afternoon.
You've got a BETTER solution.
It's totally automatic.
Congratulations!
Have a nice day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks