I have been handed a hot pile of steaming yuck and need some help with the final part of it.
In the attached example you can see row 2-4 had data for 3 separate items. Column G is my achilleas heel now.
For example Col 2 needs to be broken down into 4 SEPARATE rows line 11-14.
This file sometimes will have only 1 or 30 in G so its not always going to be 4. The actual file is HUGE so its not something I would like to do manually at this point.
Since you have Office 365, use Power Query.
Assuming that you don't need to keep the hidden column ([UPC]).
Sample M code:
Sample file attached.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Try.Please Login or Register to view this content.
Best Regards,
Maras.
An, late to the party, another option to expand the data in-situ.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Power Query with UPC
Please Login or Register to view this content.
This is all amazing guys, thank you SO much for your help with this. For ME, the best one of these to use would be TMS, but again, thank you too all.
I do have one last question that is related to this thread.
How would this be re-written so that D1000 is the variable "lLR"?Please Login or Register to view this content.
You're welcome.
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
Last edited by TMS; 02-02-2021 at 12:13 PM.
RATS!!!!! TMS, I JUST realized that it's BOTH columns G AND H that need to be broken down. The good news is that G and H coincide with each other so there will always be an H to go with the G.... Does that make sense?
I tried to alter the code myself but was unsuccessful. Help, please.....
This should do it:
Please Login or Register to view this content.
YEP! that worked! Thank you so much!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks