Hello!
I'm trying to design a workflow that takes a data set that has some duplicated columns (essentially), and transposes some of the information into individual columns. I've included a sample input that shows the beginnings of what my input looks like, and what my goal of an output would look like as well. Essentially, my dataset has a column for name and ID number, and then groups of columns to show the following: Week, Subscribers, VIP, Product, and Cost. These columns are duplicated for each week, and the week header will always be in date format. My goal is to transpose the data as shown in the output, where each individual date is listed in order for each ID number. I'm assuming I'll need to do some form of dynamic rename, since I won't always know what the "Week" date will be, and since there are duplicated columns on my input for each week. Any thoughts/help would be greatly appreciated! Thank you for your time!
