getting the row and column headings per variable, plus...

20 views
Skip to first unread message

Johnpaul Menchavez

unread,
Jan 31, 2023, 1:18:27 AM1/31/23
to Google Apps Script Community
Thanks for at least reading this request for help. I'm very new here. I request for a tip or advice on Apps Script. How could I program this?

Here is my data:
Screenshot 2023-01-31 140903.pngHi 

And here is the output I want:
Screenshot 2023-01-31 141522.png

It's basically getting the column and row heading for each for 1, 2 and 3. For some rows, at times, there is a letter i with the #, which requires a longer operation since that means a-30 if z=a...

Thanks a lot! 

Mustafa Teke

unread,
Mar 1, 2023, 4:09:16 AM3/1/23
to google-apps-sc...@googlegroups.com


31 Oca 2023 Sal, saat 09:18 tarihinde Johnpaul Menchavez <dean...@gmail.com> şunu yazdı:
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/851ebf65-65a0-4c9b-be0b-9510df19a4den%40googlegroups.com.
--
🏌️

Johnpaul Menchavez

unread,
Mar 1, 2023, 5:21:10 PM3/1/23
to google-apps-sc...@googlegroups.com
Thanks. Blank message though.

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/Z9TmHPjxKbI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAN-DKD_7%2B03bs8rwqpNf7_Pk2fkOaJMRxd7joKhRHAc7Fma5Eg%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages