Hi there,
A newbie here. I have been trying to convert my data for hours but could not manage to do so. Any help is greatly appreciated.
I have data for 50 US states and this is how my data looks:
year state unemp
2020 Alabama 5.5
2021 Alabama 4.5
2022 Alabama 4.0
2020 Alaska 6.2
2021 Alaska 6.0
2022 Alaska 6.5
2020 Arizona 4.3
2021 Arizona 3.4
2022 Arizona 3.1
... ..... ...
How can I convert it to look like this:
Year Alabama (unemp) Alaska (unemp) Arizona (unemp)
2020 5.5 6.2 4.3
2021 4.5 6.0 3.4
2022 4.0 6.5 3.1