

July 6, 2021

Hello,
I'm wondering if there is a way to pull data into a different sheet that are grouped together into similar component numbers. I have a list of asset component numbers with associated descriptions and I want to combine all the descriptions with the same component groupings (A2, A3, A4, A5, A6, etc.) and transfer to a different cell.
For example, anything that has an asset number beginning with A5, I want to be able to copy those descriptions into a single cell. The attached spreadsheet shows the example of what we want to accomplish. The Data sheet contains the list as is and the What we want sheet is what we need the original list to become.
Please let me know if you can help...any help would be very much appreciated
Thanks & have a nice day!
Annalisa


September 9, 2020

Hi Annalisa Loh,
I suggest you work with Power Query.
- The first step is to import your data into Power Query
- Then you separate your data to get the 'Assest' code.
- Then, you group your data by combining the different elements (by 'Assest')
- Finally, you put your results back into Excel (Result sheet)
BR,
Lionel


Trusted Members

February 13, 2021



Trusted Members
Moderators

November 1, 2018



July 6, 2021

Thank you for all the replies/suggestions.
Lionel & Velouria,
Thank you for your help so that I am able to get the needed results. I have a further question:
If I do this in Power Query, is there a way to have this repeated for many workbooks without having to create a new query for each file? Basically, is there a way to have this query saved and then applied to other workbooks? Or will I need to do this for every separate report? The reports cannot be combined because they are for different sites and locations.
Any further help or suggestions would be greatly appreciated.
Thanks,
Annalisa
1 Guest(s)
