I am attempting to find a simplified workaround for an excel problem. I have multiple lead lists with different columns of information. What I'd like to do:
1.) Combine multiple lists into a single spreadsheet.
2.) Merge multiple rows with varying column headers into a single row and have all the information merge into that single row.
Does anyone have a simplified means to do this without purchasing a separate software solution? If not, is there a software app out there that is relatively inexpensive?
I have attached an example of what I'm attempting to accomplish.
Thank you in advance for any assistance!
