Forum Discussion
Query; conditional column across tables
Wonderful,
In that case keep the first column you created in the Statuses table and then create a merge between your two tables. Merge on status and then expand the column that you previously created.
Top right in the PowerQuery Editor
I think this should give you the correct result,
/ J
No, these are all unique entries.
Wonderful,
In that case keep the first column you created in the Statuses table and then create a merge between your two tables. Merge on status and then expand the column that you previously created.
Top right in the PowerQuery Editor
I think this should give you the correct result,
/ J
Great thank you, working as I expected.
Frustrating, I'd managed to get the table appended like this somehow, I must have manually written a merge in the function bar (!!) but didn't realise I was just one expand away from what I needed.