You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
aggi-
Yes. I need a few number text concatenations. But I thought Text.From(xxx) would deal with it.
Now I have a sort of grasp of what I'm doing I'm going to start again.
Being able to tidy up and remove the unnecessary columns without xls crashing has been a real game changer.
And I'm hoping by copying that detailed view thing I can copy and save that to re-run all these early steps.
Unfortunately where I really struggle is with more detailed formulas - e.g. I want to look for a matching UID against the whole colum of UID where the value of another column = "hamster" then when there is >1 result concat those with a ; delimiter. In excel I can just about work it out, but 0
hugo7
Going round in circles with PQ.
When I try and load i get
How do I identify the problem area?
Basically I've deleted a load of columns and added some new concat columns, but I swear to god I've been through all of those to check they're packed full of Text.From
I was hoping to load at this point because the sheet should be more manageable and I can't get my if lookup to return a result in PQ.