Forum Discussion
rodsan724
Oct 27, 2023Brass Contributor
Align the column values with each other so you can easily see what's missing
I have some data on the attached worksheet. This is a side by side comparison of file contents. Column1 is the control, it has everything. The desire is to automate aligning the data so you can easil...
Lorenzo
Nov 02, 2023Silver Contributor
Assuming there's a reliable/consistent way to distinguish Fields and SubFields (Artist: & *Track: in below example):
this looks doable with Get & Transform aka Power Query: