Data in one column to be reflected in multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2573565%22%20slang%3D%22en-US%22%3EData%20in%20one%20column%20to%20be%20reflected%20in%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2573565%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20cost%20centers%20(repeating)%20that%20have%20various%20locations%20that%20are%20applicable%20to%20each%20of%20them%20(this%20is%20valued%20data%20from%20a%20pivot%20table).%26nbsp%3B%20I'm%20trying%20to%20show%20the%20cost%20center%20in%20one%20cell%20with%20the%20locations%20showing%20in%20separate%20cells%20on%20the%20same%20line%20but%20in%20separate%20columns%20(see%20attachment).%26nbsp%3B%20How%20can%20this%20be%20accomplished%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20fairly%20large%20file%20with%20data%20and%20some%20cost%20centers%20have%2020%20or%20more%20locations%20associated%20with%20them.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2573565%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2573715%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20in%20one%20column%20to%20be%20reflected%20in%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2573715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1109654%22%20target%3D%22_blank%22%3E%40E_Run1010%3C%2FA%3E%26nbsp%3Bif%20you%20are%20an%20MS365%20subscriber%20you%20can%20use%20UNIQUE%20and%20a%20combination%20of%20the%20TRANSPOSE%20and%20FILTER%20functions.%20I%20changed%20the%20example%20data%20a%20bit%20to%20demonstrate%20this.%20See%20attached%2C%20rows%2014%3A16.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

1 Reply

@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.