Automatic data entry manipulation

[fredawkw]

Hi Excel Community,

I'm using Office 365. And I want to manage my data using excel. below is my sample data.

Raw

Campaign	Ad group	Keyword	Copy
Campaign 1	Ad group 1	Keyword 1	A
Campaign 1	Ad group 1	Keyword 2	A
Campaign 1	Ad group 2	Keyword 3	A
Campaign 1	Ad group 3	Keyword 4	A
Campaign 2	Ad group 4	Keyword 5	A

And want to restructure as below

Filter: Copy

Campaign1			Campaign 2
Ad group 1	Ad group 2	Ad group 3	Ad group 4
Keyword 1	Keyword 3	Keyword 4	Keyword 5
Keyword 2

[#2]

Hi @fredawkw 

With Power Query (attached):

With your data in table RawData > Switch to sheet Desctructured > Right-click in the green/white table > Refresh