I am extracting spreadsheets from a folder. All of the spreadsheets are in the same format. I am then aggregating all of the data together to make a database.
I have a date that is in one cell in the spreadsheet (same cell throughout the entire folder). I would like to extract the date, make a new column out of it, and copy down the value 65 times.
I tried using the transpose tool, but it misaligns the rest of the dataset. I have attached what I have so far.
@casey893 would you be able to provide a sample file and expected result
Hi, @casey893
A sample file will go a long way 😎
However, looking at your workflow, I do not show any Transpose Tool in use...
Else, are you trying to append the Date as an additional column using the Append Tool?
Hi @casey893
This post may help you to get your questions answered faster Get Answers Fast keep in mind our time is limited and althought your problem/challenge is clear to you, it is not for us.
Hope this helps
Arnaldo
Get Answers FAST (some ideas to get your questions quickly answered)
Hi @RobertOdera ,
I have the transpose tool disconnected right now because I am trying out alternative methods, but at one point it was connected. I will put together some dummy data.