Power Query Unpivot?

[shophoney]

HI, I have a power query table with payments made on a transaction. I would like to have all payments on one line for each transaction so I can link them to the sales table.

But if a customer paid with 2 credit cards in power query it is listed on 2 lines. I was hoping to use the un pivot and have the types of tenders on the top and the amounts going down.

 

[sandy666]

post a link to the shared, desensitized excel example file
structure and type of data should be reflected
use OneDrive, GoogleDrive or any similar to get a link

 

[nikio8]

It seems you do not need to unpivot. Just use pivot table on your data. perhaps add a column, which will say, amex, eftpos, paypal...
Then add transaction, date, customer name in rows; tender type in columns, amount in values.

unpivot is when you have summary table, Jo, Bo Len, total payments on Mon Tue Wed.
Then you can unpivot to Jo Mon 4, Jo Tue 4, Jo Wed 5, which can be put in pivot table.

hope it helps