Challenge #93: Pumpkin Production

[Inactive User]

Easy, but long.

Spoiler

Did a Text to Columns followed by Dynamic Rename and used select to change Type to Double on Data 2.
Replaced commas in Data 1.
Joined data.
Summarized twice, one by year and another by state.
Used 4 Joins.
Sorted data and renamed and reordered columns.

[bjkay30]

Interesting challenge.  I even learned the PadLeft formula for a co-worker on this one!!

Spoiler

[T_Willins]

Catching up on previous challenges.

Spoiler

[Inactive User]

[chetty]

My solution attached

[Laszlo_D]

[Laszlo_D]

[AndrewS]

#93

[hanykowska]

It took me embarrassingly long to figure out the objective of this challenge. But got it in the end!

[saurabh307singh]

Here is my approach. Took quite a lot of time and used a lot of tools

Spoiler