Requesting help in creating table format

[Manjari]

Hi All, 

Requesting help in creating table format

I have a sample table like this: 

ID	year
123	2016
123	2017
123	2018
123	2019
456	2016
456	2017
456	2018
456	2019

I want the output to look like this

ID	2016	2017	2018	2019
123	2016	2017	2018	2019
456	2016	2017	2018	2019

[atcodedog05 · Accepted solution]

Hi @Manjari 

Here is how you can do it. Using crosstab.

Workflow:

Hope this helps : )

[Manjari]

Thank you @atcodedog05  worked like a charm. 

[atcodedog05]

Happy to help : ) @Manjari 

Cheers and have a nice day!