Forum Discussion
Combine cells when column match
Hi Everyone, I don't know how to explain it well, so I'll show you a table of what I need to do. I have this: Year Model Item Number 1984 A 100 1985 A 100 1986 A 100 1...
A pivot table comes close, though it doesn allow the same layout as you showed, see attached.
Thank you for your reply, I need it in the other format so it can be read by another program, I'll keep trying with pivot tables in mind though.
If the Excel version you use has TEXTJOIN Function, you may use JKPieterse's example to join the text that you want.
I am using Excel 2013 that does not have TEXTJOIN function and I am not familiar with PivotTable. If you needs the formula solution, please try the attached file. However, I created some helper columns and NAME formula.
I am not sure if there are any Power Query solutions.
