The title is not very accurate, but I'm looking for help to merge (or append) two (or more) tables from Power Query.
In the attached example, I have a range of from and to inputs of various information (in this case, for a railway example project rail- and superstructure types).
I have imported both tables into Power Query, and tried to both combine and append them, but the results are not exactly what I'm looking form
I've added a tab called "Goal" to show what I'm trying to accomplish.
I will need to add additional information in the same type of formatting at a later stage, so anything that automates this process is greatly appreciated!
Hopefully someone will be able to help.
Best Regards,
Bookmarks