•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
consolidate all text relating to an item in one cell
So I have a table that looks like the below:
| Door | Item | Price |
|---|---|---|
| Door1 | Item1 | 10 |
| Door1 | Item2 | 13 |
| Door2 | Item1 | 10 |
| Door2 | Item3 | 14 |
| Door2 | Item5 | 12 |
| Door3 | Item1 | 12 |
I want to consolidate the list of Items into one field per door
| Door | Item |
|---|---|
| Door1 | Item1 /n Item2 |
| Door2 | Item1 /n Item3 |
| Door3 | Item1 |
I'm only putting the /n because I can't put in a new line in reddit tables.
I want it to be
Item1
Item2
I think I can do this in power query but I'm not sure how, I can't think of a way to do it with just formulas.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#consolidate
#power query
#table
#Door
#Item
#Price
#formula
#text aggregation
#field
#list
#data organization
#new line
#reddit tables
#Item1
#Item2