Extracting date from one cell and copying that value down into a new column

Question

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.

Workflow.png

casey893 · Answer

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.

ArnaldoSandoval · Answer

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)

RobertOdera · Answer

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?