Converting data in a report into data that be loaded into a database table

[DonnaRonna]

Hi,

First off, I love this board! Very helpful.

I have a report (excel format) of data that has the amounts for each date in a separate column:

Descriptor Descriptor Jan-18 Feb-18 Mar-18 and so forth

 

[DonnaRonna]

wow, I hit a key and submitted this without finishing. sorry about that.

Descriptor Descriptor Jan-18 Feb-18 Mar-18
Widget Red $5 $10 $10

What I need, in order to load the data into a table in the database is:

Descriptor Descriptor $ Date
Widget Red $5 Jan-18
Widget Red $10 Feb-18
Widget Red $12 Mar-18

Any ideas?

Thanks in advance

DonnaRonna

 

[sandy666]

If you are able to use PowerQuery aka Get&Transform, try

Descriptor	Descriptor2	Jan-18	Feb-18	Mar-18		Descriptor	Descriptor2	Value	Attribute
Widget	Red	$5	$10	$10		Widget	Red	$5	Jan-18
						Widget	Red	$10	Feb-18
						Widget	Red	$10	Mar-18

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Descriptor", "Descriptor2"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Other Columns",{"Descriptor", "Descriptor2", "Value", "Attribute"})
in
    #"Reordered Columns"[/SIZE]