Create new rows based on column data

[Emmeli]

Hi 

I would like your help with a problem of mine I'm trying to do a graph in power bi were I can se cost and the budget over time like in the graph below.

The problem I have is that the data I can download comes in this format.

Cost center	Acc2	Accont	Akt	Proj	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
11220 Logistic	36 Sale	36900 services sold			778	778	778	778	778	500	500	778	778	778	778	778
11222 Logistic	62 IT-cost	62100 Rent IT-appl			-85	-85	-85	-85	-85	-85	-85	-85	-85	-85	-85	-85
11223 Logistic	64 Inv	64500 Office appliances			-404	-404	-404	-414	-414	-414	-414	-414	-414	-414	-414	-414

But in order for it to work properly in power BI I would like the data to have this format. Or I think I need it to be in this format. How can I create this?

Cost center	Acc2	Accont	Month	Budget
11220 Logistic	36 Sale	36900 services sold	Jan	778
11220 Logistic	36 Sale	36900 services sold	Feb	778
11220 Logistic	36 Sale	36900 services sold	Mar	778
11220 Logistic	36 Sale	36900 services sold	Apr	778
11220 Logistic	36 Sale	36900 services sold	May	778
11220 Logistic	36 Sale	36900 services sold	Jun	500
11220 Logistic	36 Sale	36900 services sold	Jul	500
11220 Logistic	36 Sale	36900 services sold	Aug	778
11220 Logistic	36 Sale	36900 services sold	Sep	778
11220 Logistic	36 Sale	36900 services sold	Oct	778
11220 Logistic	36 Sale	36900 services sold	Nov	778
11220 Logistic	36 Sale	36900 services sold	Dec	778
11222 Logistic	62 IT-cost	62100 Rent IT-appl	Jan	85
11223 Logistic	63 IT-cost	62101 Rent IT-appl	Feb	85
11224 Logistic	64 IT-cost	62102 Rent IT-appl	Mar	85
11225 Logistic	65 IT-cost	62103 Rent IT-appl	Apr	85
11226 Logistic	66 IT-cost	62104 Rent IT-appl	May	85
11227 Logistic	67 IT-cost	62105 Rent IT-appl	Jun	85
11228 Logistic	68 IT-cost	62106 Rent IT-appl	Jul	85
11229 Logistic	69 IT-cost	62107 Rent IT-appl	Aug	85
11230 Logistic	70 IT-cost	62108 Rent IT-appl	Sep	85
11231 Logistic	71 IT-cost	62109 Rent IT-appl	Oct	85
11232 Logistic	72 IT-cost	62110 Rent IT-appl	Nov	85
11233 Logistic	73 IT-cost	62111 Rent IT-appl	Dec	85
11223 Logistic	64 Inv	64500 Office appliances	Jan	-404
11224 Logistic	65 Inv	64501 Office appliances	Feb	-404
11225 Logistic	66 Inv	64502 Office appliances	Mar	-404
11226 Logistic	67 Inv	64503 Office appliances	Apr	-414
11227 Logistic	68 Inv	64504 Office appliances	May	-414
11228 Logistic	69 Inv	64505 Office appliances	Jun	-414
11229 Logistic	70 Inv	64506 Office appliances	Jul	-414
11230 Logistic	71 Inv	64507 Office appliances	Aug	-414
11231 Logistic	72 Inv	64508 Office appliances	Sep	-414
11232 Logistic	73 Inv	64509 Office appliances	Oct	-414
11233 Logistic	74 Inv	64510 Office appliances	Nov	-414
11234 Logistic	75 Inv	64511 Office appliances	Dec	-414

[Emmeli]

R U Kidding me! It was that easy. Thank you, thank you, thank you😀

[barritown · Accepted solution]

Hello @Emmeli,

The easiest way to perform this would be via PowerQuery: 

- you select all the month columns;

- and unpivot them (then you can remove those columns that are not needed and rename the newly created).

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian