Cross Tab columns with ID Numbers, Values and Date

[Kutay]

Hi everybody,

I received a  dataset with the following order below. 

Record	JSON Name	JSON Value String
1	0.adtagID	6565
2	0.distinctpageseen	1
3	0.firsttimeseen	2020-02-05
4	0.lasttimeseen	2020-02-05
5	1.adtagID	6587
6	1.distinctpageseen	1
7	1.firsttimeseen	2020-02-05
8	1.lasttimeseen	2020-02-05
9	1.profiletime	1

I would like to convert it into sth like this:

Record	AdTagID	Distinctpageseen	firsttimeseen	lasttimeseen	profiletime
1	6565	1	2020-05-05	2020-05-05	N/A
2	6587	1	2020-05-05	2020-05-05	1

I tried to use couple of functions but not able to solve. As a new user I need some help:)

Thanks in advance.

Kutay

[DavidP]

The key is to separate JSON Name with Text to columns, then crosstab

[JosephSerpis]

Hi @Kutay I mocked up a workflow that shows how to do this.

[Kutay · Accepted solution]

Hi David,

Thank you so much for your help. I tried and it worked perfectly!

Kind Regards,

Kutay

[Kutay]

Thank you so much Joseph! I tried your solution as well and helped me a lot too!

Kind Regards,

Kutay