Convert 6 Columns of Data to a 3 Column Table
I was reading about the frequency with certain SERP features (images, videos, local pack (maps), etc.) were shared and wanted to save a copy of the data that was presented so I could filter it to share with clients when needed. Here is a sample of what the data looked like.
I simply copied the data (source is SEMRush), pasted it into ChatGPT and asked “him” (yes I have gendered Chatty in my own mind LOL) to convert the data into a table. Here is the output:
I quickly realized that I wanted to see the data in order of highest percent to lowest so asked Chatty to do this, after which I received a table sorted as I desired:
- About the Author
- Latest Posts
Darlene is a search marketer, analyst, speaker, trainer, and owner of DriveTraffic Digital Marketing. She has been working in the digital marketing industry since the mid 90s and has narrowed her specialty to SEO, Google Ads and Google Analytics. She is especially interested in Google’s new Search Generative Experience and how businesses will need to adapt to remain visible. Want to see how DriveTraffic can help? Let’s chat!
