Forum Discussion
Data in one column to be reflected in multiple columns
I have a column of cost centers (repeating) that have various locations that are applicable to each of them (this is valued data from a pivot table). I'm trying to show the cost center in one cell w...
E_Run1010 if you are an MS365 subscriber you can use UNIQUE and a combination of the TRANSPOSE and FILTER functions. I changed the example data a bit to demonstrate this. See attached, rows 14:16.