Convert 6 Columns of Data to a 3 Column Table
- Category: AI
- Date modified: May • 2024
- Date created:
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 founded DriveTraffic Digital Marketing in the late 1990’s. She 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!
