Forum Discussion
Cristianst
Nov 28, 2018Copper Contributor
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...
JKPieterse
Nov 28, 2018Silver Contributor
A pivot table comes close, though it doesn allow the same layout as you showed, see attached.
Cristianst
Nov 28, 2018Copper Contributor
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.
- Willy LauNov 28, 2018Iron Contributor
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.