Pivoting data in query editor

Power Query
1

I have attached the same test file
test.pbix (20.0 KB)
It contains only a few rows of data

Device	Description	Property	Value
AVGSGVM01	Application	License Key	-
AVGSGVM01	Application	License Type	-
AVGSGVM01	Application	Product ID	-
AVGSGVM01	Application	Display Name	ScreenConnect Client (806a9ca35e36b38a)
AVGSGVM01	Application	Installation Date	27/09/2022
AVGSGVM01	Application	Publisher	ScreenConnect Software
AVGSGVM01	Application	Version	22.6.8531.8234

AVGSGVM01	Application	License Key	-
AVGSGVM01	Application	License Type	-
AVGSGVM01	Application	Product ID	-
AVGSGVM01	Application	Display Name	Microsoft 365 Apps for enterprise - en-us
AVGSGVM01	Application	Installation Date	-
AVGSGVM01	Application	Publisher	Microsoft Corporation
AVGSGVM01	Application	Version	16.0.15629.20156
AVGSGVM01	Application	License Key	-
AVGSGVM01	Application	License Type	-
AVGSGVM01	Application	Product ID	-

I need to arrange this so that there is one entrey per application publisher with the underlying rows formatted into columns

|Device|Description|Display Name|Installation Date|License Key|License Type|Product ID|Publisher|Version|
|---|---|---|---|---|---|---|---|---|
|AVGSGVM01|Application|ScreenConnect Client (806a9ca35e36b38a)|-|-|-|-|ScreenConnect Software|22.6.8531.8234|
|AVGSGVM01|Application|Microsoft 365 Apps for enterprise - en-us|-|-|-|-|Microsoft Corporation|16.0.15629.20156|

I am sure it can be done using a form of pivot / unpivot

2

@Synergetic test.pbix (31.4 KB)
Asset.csv (711 Bytes)

image
image994×78 5.31 KB

I removed the last 3 rows as the data wasn’t complete

1 Like
3

Thank you.
This is exactly what I am after.

4

Hi @Synergetic, did the response provided by @AntrikshSharma help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

5

Hello @Synergetic, did the response above help solve your query? It’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.