• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA instead of Power Query

J

jharding

New Member
i had created an excel sheet that took 4 columns of data (week, meal time, meal name, food item) and transposed and grouped that data using power query to create a list of food items, by week (columns) and grouped by meal time/name as rows.
unfortunately, this was developed for a mac, where Excel for mac wont recognize power query or pivot tools and scripts

I'm trying to think if I could write VBA code to perform the same function:
1) Find unique week numbers (column a) and list each as column in result tab
2.) list meal time/meal names (column b and c, concatenated) as rows
3.) group food items (column d) into each week column and meal row.

Columns A-D are in a defined table (Table1), so I can use listobject class as my reference
Where would I start with this?
Thank you for your help
 
jharding
After You have take care those Cross Postings,
You would check this sample.
Press [ Do It ] ; cell F1
ps This do not take care formats.
 

Attachments

  • Test.xlsb
    33.4 KB · Views: 8
This is fantastic. With a little bit of tweaking, I was able to use the code directly in my project. I also learned some new methods as well

Thank you so much
 
You must log in or register to reply here.
Back
Top