Identifying Formula or Function Needed

%3CLINGO-SUB%20id%3D%22lingo-sub-1504242%22%20slang%3D%22en-US%22%3EIdentifying%20Formula%20or%20Function%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504242%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20census%20spreadsheet%20where%20an%20employee's%20name%20is%20listed%20on%20multiple%20lines.%20Each%20line%20represents%20a%20different%20line%20of%20coverage%20they%20are%20enrolled%20in.%20I%20am%20trying%20to%20turn%20each%20line%20of%20coverage%20into%20it's%20own%20column%20so%20each%20employee%20only%20has%20one%20line.%20I%20have%20attached%20an%20example%20with%20coordinating%20colors%20for%20where%20I%20am%20wanting%20the%20data%20to%20go.%20I%20am%20not%20sure%20what%20formula%2Ffunction%20is%20going%20to%20work%20best%20to%20accomplish%20this.%20Please%20help!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504242%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I have a census spreadsheet where an employee's name is listed on multiple lines. Each line represents a different line of coverage they are enrolled in. I am trying to turn each line of coverage into it's own column so each employee only has one line. I have attached an example with coordinating colors for where I am wanting the data to go. I am not sure what formula/function is going to work best to accomplish this. Please help! 

3 Replies
Highlighted

@CBeynon , I went the Power Query route to solve your problem. I converted the data into an Excel Table so you can add more rows and click Data->Refresh All and the summary tab will have the modified data.

Highlighted

@TheAntonythanks so much for the help!!

Highlighted

@CBeynon , Glad I could help!