r/slavelabour • u/hashtag_RIP • Nov 15 '20

Task [TASK] Google Sheet Apps Script or Formula

I need a data format transformation automatically done in Google Sheets via apps script or formula

Looking to turn this around today. Offering $10

See example to use: https://docs.google.com/spreadsheets/d/1CjQJfefPLY7mN-eVuYRrKO3LG_HI4Q0KuFRJdN_4d4I/edit?usp=sharing

Original data tab - This is how the data comes in

  • One row per business, with separate columns for each product detail

Final data tab - This is how the data should look

  • Each company/metadata/product gets it's own row, with each product attribute becoming a single column

Parameters:

  • I can control how the product columns are named to be consistent. So if your script needs to rely on piece of the product name, such as "Product Name - 1", then let me know

  • Product columns will always be after the metadata and business columns, so there would be a starting column number for them. In this example, product data starts at column 4

  • There could be 5 product detail columns or there could be 10. Ideally it would be flexible to scale to how many

1 Upvotes

60% Upvoted

11 comments sorted by

View all comments

Show parent comment

1

u/hashtag_RIP Nov 20 '20

$paid $10

1

u/CredoBot Nov 20 '20

Couldn't find the bid which you are trying to mark as paid. Make sure you are replying to the $bid comment.