Forum Discussion

E_Run1010's avatar
E_Run1010
Copper Contributor
Jul 22, 2021

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 with the locations showing in separate cells on the same line but in separate columns (see attachment).  How can this be accomplished? 

I have a fairly large file with data and some cost centers have 20 or more locations associated with them.

Thanks.

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 22, 2021

    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.

     

Resources