Forum Discussion
Combine multiple results in to 1 row
- Hi,
I've already solved it with that attached file. L.Z. was giving me a simpler option that I don't have the option to use. I added my solution in case it would help anyone else not looking for an answer but I don't know how to mark the thread closed. Thanks anyway. - Hi, your attach file too many rows to be understood.
If possible, few rows may easy to catch what you want. - Looks right to me, Just need the last contact column.
company doesn't have power query installed
Have you solved this problem without PowerQuery?
If not, could you please provide your expected result.
I am not clear what you mean "last contact column".
Could you please provide some background of this question?
I am not sure what you want exactly. - Thanks. Looks great. My company doesn't have power query installed and I'm not allowed to install it. But thanks anyway. It looks a lot simpler.
Looks right to me, Just need the last contact column. I've deleted the old and reattached an amended base sample
Well, I'm not going to do the job twice as in the last workbook I shared I already fixed the [Customer]s that had several [Account Number]s (i.e. Customer 12). That said no problem to add a [Last Contact] column if you wish but...
IF the Power Query option I shared does it, you shouldn't need it. I haven't checked all but in the attached workbook you'll find in 'PQ vs PVT' the output of the query vs. a PivotTable. A quick comparison gives me the impression they produce the same results and by activating the Grand Total fos rows you get the extra column you expect. Last but not least a Pivot Table approach will be more efficient
Let me know your thoughts and any issue
- Looks right to me, Just need the last contact column. I've deleted the old and reattached an amended base sample
