Dear Experts,
Problem: I have a data source and reference
Output 1: Create a data source with unique items and columns only based on the reference
Output 2: Vlookup / any other look up to show all the data source which match the product ID of reference.
Is it possible to rearrange the excel sheet columns only based on reference sheet which occasionally change and as there are many columns, look for a smarter way.
Please can you see the uploaded pictures and guide me the steps.
Thanks in advance.
Problem: I have a data source and reference
Output 1: Create a data source with unique items and columns only based on the reference
Output 2: Vlookup / any other look up to show all the data source which match the product ID of reference.
Is it possible to rearrange the excel sheet columns only based on reference sheet which occasionally change and as there are many columns, look for a smarter way.
Please can you see the uploaded pictures and guide me the steps.
Thanks in advance.