How to Transpose Columns in a table

Question

Hi Friends&nbsp;This is Nagarjuna. I Have a small query, Can u please help me on this?&nbsp;I was created the below table in Power BI&nbsp;Column A SumColumn B SumColumn C SumColumn D SumColumn E SumColumn F SumColumn G SumColumn H Sum100200150180210220230250&nbsp;I want to&nbsp;transpose the above table. i.e i need the table like the below one&nbsp;Column A Sum100Column B Sum200Column C Sum150Column D Sum180Column E Sum210Column F Sum220Column G Sum230Column H Sum250&nbsp;&nbsp;And i need the graph like below one&nbsp;&nbsp;How this possible in power BI&nbsp;&nbsp;Thanks in AdvanceRegardsNagarjuna&nbsp;

v-huizhn-msft · Answer

Hi&nbsp;Nagarjunav,I reproduce your scenario and get expected result, please follow the steps below.1. Right click your sample table-&gt;Edit Query, select all columns-&gt; click unpivot columns(lighted in yellow)-&gt;click "Apply" on home page. You will transpose columns in the table.Here is my Power Query statement.
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwUNJRMgKThqZg0gIsYggmjcCkMZgEysbGAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Column A Sum" = _t, #"Column B Sum" = _t, #"Column C Sum" = _t, #"Column D Sum" = _t, #"Column E Sum" = _t, #"Column F Sum" = _t, #"Column G Sum" = _t, #"Column H Sum" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column A Sum", Int64.Type}, {"Column B Sum", Int64.Type}, {"Column C Sum", Int64.Type}, {"Column D Sum", Int64.Type}, {"Column E Sum", Int64.Type}, {"Column F Sum", Int64.Type}, {"Column G Sum", Int64.Type}, {"Column H Sum", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value")
in
    #"Unpivoted Columns"
2. You can line chart, select "Attribute" as x-axis, value as value, you will get expected result.Best Regards,Angelia

nagarjunav · Answer

Thanks for your reply&nbsp;v-huizhn-msft&nbsp;What i posted&nbsp;was not my raw-data, those columns are the calculated columns. I Have 30 columns raw-data and 100 calculated columns.&nbsp;I am changing my sample data for better understanding.&nbsp;Here first 3 columns are Raw-data columns, 4th column onwards calculated onesTransaction IDSupplier NameAmountAmount &lt;250250&lt;=Amount &lt; 450&nbsp;450&lt;=Amount &lt; 650&nbsp;650&lt;=Amount &lt; 850&nbsp;850&lt;=Amount &lt; 1050&nbsp;1050&lt;=Amount &lt; 1250&nbsp;1250&lt;=Amount &lt; 1450&nbsp;Amount &gt;14501A100100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2B200200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3C300&nbsp;300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4D400&nbsp;400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5E500&nbsp;&nbsp;500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6F600&nbsp;&nbsp;600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7G700&nbsp;&nbsp;&nbsp;700&nbsp;&nbsp;&nbsp;&nbsp;8H800&nbsp;&nbsp;&nbsp;800&nbsp;&nbsp;&nbsp;&nbsp;9B900&nbsp;&nbsp;&nbsp;&nbsp;900&nbsp;&nbsp;&nbsp;10E1000&nbsp;&nbsp;&nbsp;&nbsp;1000&nbsp;&nbsp;&nbsp;11H1100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1100&nbsp;&nbsp;12F1200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1200&nbsp;&nbsp;13C1300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1300&nbsp;14A1400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1400&nbsp;15E1500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1500&nbsp;&nbsp;Now i need the table like below one&nbsp;&nbsp;RangeAmountAmount &lt;250300250&lt;=Amount &lt; 450&nbsp;700450&lt;=Amount &lt; 650&nbsp;1100650&lt;=Amount &lt; 850&nbsp;1500850&lt;=Amount &lt; 1050&nbsp;19001050&lt;=Amount &lt; 1250&nbsp;23001250&lt;=Amount &lt; 1450&nbsp;2700Amount &gt;14501500&nbsp;If the table comes like this, automatically we can draw the required graphi.e.&nbsp;&nbsp;&nbsp;&nbsp;Thanks in advanceRegardsNagarjuna&nbsp;&nbsp;

Forum Discussion

How to Transpose Columns in a table

2 Replies

Related content

Transpose table column values

Help Transposing

Transpose/ Transform Rows to Columns

Transpose the table with specific rule

Transpose row and column in visualization table

Column A Sum	Column B Sum	Column C Sum	Column D Sum	Column E Sum	Column F Sum	Column G Sum	Column H Sum
100	200	150	180	210	220	230	250

Transaction ID	Supplier Name	Amount	Amount <250	250<=Amount < 450	450<=Amount < 650	650<=Amount < 850	850<=Amount < 1050	1050<=Amount < 1250	1250<=Amount < 1450	Amount >1450
1	A	100	100
2	B	200	200
3	C	300		300
4	D	400		400
5	E	500			500
6	F	600			600
7	G	700				700
8	H	800				800
9	B	900					900
10	E	1000					1000
11	H	1100						1100
12	F	1200						1200
13	C	1300							1300
14	A	1400							1400
15	E	1500								1500

Range	Amount
Amount <250	300
250<=Amount < 450	700
450<=Amount < 650	1100
650<=Amount < 850	1500
850<=Amount < 1050	1900
1050<=Amount < 1250	2300
1250<=Amount < 1450	2700
Amount >1450	1500