Can anyone please advise how to auto-rearrange rows of data, based on desired arrangement?
I would like to automate the process using Excel VBA/Macros.
For example, the data I have is:
Fruit Name,Jan Sales,Feb Sales
apple,130,1350
banana,200,2300
jackfruit,260,750
mango,40,430
papaya,120,2100
pear,300,780
I would like to rearrange the "Fruit Name" according to:
Fruit Name
banana
apple
pear
papaya
mango
jackfruit
My desired output is the following, based on the desired "Fruit Name" arrangement.
Fruit Name,Jan Sales,Feb Sales
banana,200,2300
apple,130,1350
pear,300,780
papaya,120,2100
mango,40,430
jackfruit,260,750
I had attached an excel file of the example.
Please advice.
Thanks a lot!
Bookmarks