Forum Discussion
INDEX Confusion: Return related data from multiple columns
Greetings community, I am having an issue with a exported file I am trying to manipulate into returning specific data based on the location of the matching reference. Situation...my company...
Eddie - Can we use something like text-to-columns to seperate the single column of exported data into individual data fields and then perform a lookup? The ability to transform data using Power Query might be an even better approach because we can reuse the transformation each time we get a new export file.