Forum Discussion
Transpose issue (maybe)
Hello! I am trying to put this data Into the format of the attached file. Essentially I need to change Coloumn "Plan_Name" into unique headers as the template asks, but I do not kno...
SergeiBaklan I appreciate your response! Yes essentially that is what I am trying to accomplish. But I don't know how the rest of the data (DOB, SSN, name, cost) will be moved to match the plan name.
To confirm, you essentially want to do this?
If so, your data can be loaded into Power Query and re-shaped quickly. Power Query refers to it as Pivoting the column. In this case, the Plan column is pivoted with Coverage as the values.