Pivot issue with Data. Data from SQL data base is showing

[bleeet]

Hi everyone,

I have an issue with one of my pivot table due to a change made in a SQL database.

There was a change made in a SQL database which caused data to I guess you can say split after a certain month.

So for example in a pivot table a persons name is shown twice because data for a person from dates say from Jan -feb is connected to one of the copies of the name. While data for that person after Mar-Sept is connected to the other copy of the name. looking like below in the pivot

Name	Jan	Feb	Mar	Apr	May
Carol	10	10
Carol			10	10	10

I am connected to the SQL database through power query and I trying to find out a way to combine to align the all peoples monthly data so that in the pivot the data on the people is all aligned in one row not two. like below. (There is about 10 or so columns in the SQL dbtable )

Name	Jan	Feb	Mar	Apr	May
Carol	10	10	10	10	10

While looking at the data through power query I see that one copy of the name has data from Jan to feb (in this example) while the other copy has data from Mar onward.

I hope everyone understands what I am describing here. I want to align my pivot report like what I have shown above but I am lost on how I can do this. not sure if this can be done in the pivot or it has to be done in power query.

 

[bleeet]

Apologies I tried to edit and add power query to the title but it seems I cannot edit the title.

 

[bleeet]

This has been solved. Note to others when having this type of issue when connecting to a SQL database be sure to trim and clean columns in power query. I did this and my issues was solved.