Jul 03 2020 05:03 PM
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!
Jul 04 2020 05:04 AM
@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.
Jul 04 2020 02:08 PM
@TheAntonythanks so much for the help!!