Forum Discussion
Resolver IHow to UNION more columns in a single column with Power Query
Community ChampionYou'll get a better answer if you post some sample data, then show what the desired result is.
--
I'm a little confused but I 'think' you want to Unpivot the columns from your original table (select all columns from the headers, right-click on the header and the option is there)
Resolver IHi HotChilli !
thanks for replay!
I'd more semplified my needs and the example. The unpivot function is not useful in my case.
Here a graphical example. I have a table like this:
A | B | C | D | E |
PB1 | PB3 | PB4 | PB5 | |
PB1 | PB2 | PB4 | ||
PB2 | PB3 | PB5 | ||
PB1 | PB3 | PB4 | ||
PB2 | PB3 | PB5 | ||
PB1 | PB2 | PB3 | PB4 | PB5 |
PB1 | PB4 | PB5 |
and I need to have from that this Table:
X |
PB1 |
PB1 |
PB1 |
PB1 |
PB1 |
PB2 |
PB2 |
PB2 |
PB2 |
PB3 |
PB3 |
PB3 |
PB3 |
PB3 |
PB4 |
PB4 |
PB4 |
PB4 |
PB4 |
PB5 |
PB5 |
PB5 |
PB5 |
PB5 |
In the mainwhile I have found by myself a solution that sound as this:
In Power Query from an empty query I have extracted columns of my interest and created my tables with:
query1= Table.SelectColumns(TableX,{"PB1"})
query2= Table.SelectColumns(TableX,{"PB2"})
and so on.
At this point I can use Append Query and I have opteined my requirements!
AgoZ